Hi, R. Choate. You are right - when you disable macro's at startup -
they wont work - but if they dont work then fine - the file dont work
but if they chose enable then one of the macro's ( on file close - not
save ) switches off all worksheets and makes only one display - then
you are asked to save - you select YES and you have just completed the
loop. When you next open the file if you select disable - the file
opens but to the last state the file saved in which was - the single
sheet being viewed. So guess what - the file cant display any other
worksheets because you didnt enable macro's. Why dont you download the
file as described elsewhere in these notes and see the function working
for yourself.
Sparx


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=539543