Posted to microsoft.public.excel.programming
|
|
Disable print not working
Dave
Dave Peterson wrote:
Did you put that code in the ThisWorkbook module? Yes.
Did you enable macros when you opened the workbook? Yes
Did you ever disable events and not enable them later? I tried this code in a workbook with no other code and it still failed to run. If I figure it out I will post back.
Thanks.
Alan
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
|