View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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