Prevent printing

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hey all, is there a way to create an Excel workbook that allows
modifications to be made, but not allow the same user or specific users from
printing the workbook? Thanks for any ideas!!

Mike
 
I would bet any solution would be macro based.

And all the specific user would have to do is open your workbook and disable
macros--or even disable events.

So the answer is not really.
 
You can disable the buttons both in the Menu and the toolbars:

CommandBars("File").Controls(x).Enabled = False
CommandBars("Standard").Controls(y).Enabled = False

where x = index of print button in menu
where y = index of print button in toolbar


Stick that in an Auto_Open macro, and unless the user disables macros
it'll work.

To
 
They can still print via File|print preview.
Or control-P or resetting the toolbars or having their own toolbars....
 
Thanks for the ideas and the heads up! At least I have the idea that if they
do print they had to put a little more effort into it to printing. If anyone
else has any more ideas let me know! Thanks again!

Mike
 
Back
Top