MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing macros and protecting the worksheet once saved (or placed on an intranet).

Posted by J Tompson on August 20, 2001 2:34 AM


I have a worksheet that contains a macro forcing users to fill in textboxes etc. However, once they click ok this file is saved (soon to be placed on a intranet). Ideally i want to deactivate the macros and protect the worksheet once this is done. Is it possible?


Posted by J Tompson on August 20, 2001 3:08 AM

Still working at it but no success....


I'm still working at it and have just tried this but it still doesn't work.

Worksheets("Quote").Enabled = False
Worksheets("Quote").Locked = False

Any ideas...