The code doesn't execute until the workbook is opened.

You could try hiding the workbook and saving it (Like personal.xls). In
your code, you then set up the workbook the way you want to see it and then
make it visible.

In the before close event, you would need to hide it again and save it.

--
Regards,
Tom Ogilvy


"Pierre via OfficeKB.com" <u13950@uwe wrote in message
news:56bae65e5fc7d@uwe...
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