About Us

royUK

Quote:

Originally Posted by 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

Protecting the VBA Project should not affect the Workbook. Have you 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 password

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Protect OK, Unprotect now messed up!	Stilla	Excel Worksheet Functions	12	January 7th 09 02:22 PM
Editing a simple macro	Connie Martin	Excel Worksheet Functions	5	November 29th 05 09:19 PM
Closing File Error	jcliquidtension	Excel Discussion (Misc queries)	4	October 20th 05 12:22 PM
Highlight Range - wrong macro, please edit.	Danny	Excel Worksheet Functions	8	October 19th 05 11:11 PM
Playing a macro from another workbook	Jim	Excel Discussion (Misc queries)	1	February 23rd 05 10:12 PM