Protect macro

S

ST

I want to protect rather hide my macro from users and at the same time
I want them to see and use workbook and save the work.When I protect my
project in VBE it does not allow me to save /and save as beacause it
asks first unprotect the sheet first.If I save the work book by putting
a password for read/modify access it exposes my macro to the users.

Any quick solution will be highly appreciated.
ST
 
R

royUK

ST said:
I want to protect rather hide my macro from users and at the same time
I want them to see and use workbook and save the work.When I protec
my
project in VBE it does not allow me to save /and save as beacause it
asks first unprotect the sheet first.If I save the work book b
putting
a password for read/modify access it exposes my macro to the users.

Any quick solution will be highly appreciated.
ST
Click to expand...

Protecting the VBA Project should not affect the Workbook. Have yo
done it correctly?

In the VB Editor, use the Tools Menu VBAProject Properties
Protection.

Then check the Lock project for Viewing box.

Type a password & confirm it.

Click OK

Close & Save the Workbook.

Your macros will now only be viewable with this passwor
 
Top