cancel printing in a book Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub Auto_Open()
    'Prevent Printing via menu
    MenuBars(xlWorksheet).Menus("File").MenuItems("Print...").Delete

'Turn off Print icon wherever it may be in the toolbars
    For J = 1 To Toolbars.Count
        For K = 1 To Toolbars(J).ToolbarButtons.Count
            If Toolbars(J).ToolbarButtons(K).Id = 2 Then
                Toolbars(J).ToolbarButtons(K).Enabled = False
            End If
            If Toolbars(J).ToolbarButtons(K).Id = 3 Then
                Toolbars(J).ToolbarButtons(K).Enabled = False
            End If
        Next K
    Next J
End Sub

Sub Auto_Close()
    'Reset the menu items
    For Each mb In MenuBars
        mb.Reset
    Next mb

'Reset the buttons
    For J = 1 To Toolbars.Count
        For K = 1 To Toolbars(J).ToolbarButtons.Count
            If Toolbars(J).ToolbarButtons(K).Id = 2 Then
                Toolbars(J).ToolbarButtons(K).Enabled = True
            End If
            If Toolbars(J).ToolbarButtons(K).Id = 3 Then
                Toolbars(J).ToolbarButtons(K).Enabled = True
            End If
        Next K
    Next J
End Sub

Private Sub Workbook_BeforePrint(Cancel As Boolean)
    Cancel = True
End Sub

No	Macro Name
1	cancel printing in a book
2	blocking printing
3	block printing (sorry no print allowed)
4	receiving messages after printing on the active sheet / page
5	cancel printing when one or more of the cells are empty
6	watermark printing (faded font on sheet / page background)
7	excel operators hk
8	print command in workbook
9	Whether to print straining
10	does not print without filling cells
11	learning with classmodule
12	perfectly deletes the menu to the right mouse and adds print print preview sheet / page structure
13	excellent menu insert file menu print print preview sheet / page structure remains
14	to preview the desired sheet / page name in the book
15	Can registration be prevented?
16	If the form is full, get the second form and print
17	to activate the desired printer
18	cancellation of print preview commands
19	active cell color ...
20	bring some of the tool buttons as a separate menu at boot

Excel Free Macros (VBA)

Cancel Printing İn A Book

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords