Thanks for the replies. Is there anyway to "allow edit" ONLY a range of cells? There are other cells I would like to disallow edit. Also, the macro is performing a "paste special" option to replace a formula. The cell that contains the formula I would like to protect to keep from accidental overwrites.
I hope that clarifies. K
Quote:
Originally Posted by Gord Dibben
Depends upon what the macro is doing.
Most times you add lines to unprotect...do your stuff.....re-protect.
To insert Comments, when you protect the sheet make sure you allow "edit
objects"
Gord Dibben MS Excel MVP
On Tue, 8 Dec 2009 01:09:10 +0000, Keyrookie
wrote:
How can you have your macros run in a protected sheet? Also, I need to
be able to insert comments. Any ideas anyone?
K
|