*You can unhide the sheets in the macro, and then hide them again, when
the action is completed, you can also protect your sheets by going to
tools,protection, protect sheets, ensure that the cells that need
changing have been unlock before you protect the sheet, *


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517763