Disable print not working
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 |
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 |
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 |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com