Disable printing problems

Hi,

I tried to disable users from printing the sheet
with this code:

Please Login or Register  to view this content.

Now the print symbol is greyed out, so that works. But I can't get
print to be disabled under File - Print.
Because I'm using a german excel I've tried renaming it to "Datei" instead of "File", changed the number to see what it disables but nothing gets greyed out really.
Any help ?
Thanks,

Simon

To stop all printing then use the BeforePrint event, don't mess with menus.

Please Login or Register  to view this content.

To stop specif sheets

Please Login or Register  to view this content.

To add it to your worksheet, do the following:

Copy the code
Select the worksheet in which you want the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

Originally Posted by Simon-ch

Thanks,

how can I restore menu items I've disabled by toying around ?...

That's why it's best not to mess around with them.

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.