Hi Jim,

The code works fine now, however,

on startup i still see the warning screen flashing by.
Is there a way to prevent this from happening?

I tried
Application.Screenupdating = False
DoEvents

but that did not do the trick...
any ideas?
Thanks,
Pierre

Jim Thomlinson wrote:
In any workbook there must be at least 1 visible sheet. You are trying to
hide all of the sheets which will not work...
Hi,

[quoted text clipped - 18 lines]
any ideas?
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200511/1