Hello everyone! Need some assistance here please.....

I'm trying to disable printing of the worksheet by regular users unless a correct admin password will be entered in an inputbox.
But on the other hand, I want all users to be able to save the worksheet in .pdf format.

I am able to do the automatic saving of worksheet to .pdf whenever the Save As option will be chosen, but since I customized the Print command with an admin password, I'm not able to do what I want for the regular users unless a general password will be entered in the same inputbox for the print command (which is where I'm really having hard time to program). Ohhh, I really hope I'm making sense here

Can anyone please help me with a code that will allow Admin user to print hard copy of worksheet; but for Regular user to only save worksheet as .pdf file.

Thanks in advance!!!

Please Login or Register  to view this content.