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