Thread
:
Disable print not working
View Single Post
#
2
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Disable print not working
Did you put that code in the ThisWorkbook module?
Did you enable macros when you opened the workbook?
Did you ever disable events and not enable them later?
wrote:
I am trying to disable printing via the menu or tool bar and I see this
response in a number of other posts. However it is not working for me.
Any thoughts? Thanks.
Alan
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson