Good evening BR

You can use a piece of code at the start of your module that will allow
macros to run without problem on protected sheets :

ActiveSheet.Protect UserInterfaceOnly:=True

This will allow your macro to make changes to your sheet with the
protection still in place. This will not automatically take effect
every time the workbook is opened, so you would have to tie it to an
event procedure to run it every time the file is used.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=471251