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

Hi,

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?

Cheers,
John


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

Still working at it but no success....

Hi,

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...