In your on close hide all but the warning sheet... Whe the book is opened if
macros are disabled then no code runs and only the warning sheet is visible.
YOu will also want to use

Application.screenupdating = false
'Your code
Application.screenupdating = true 'at the end of the sub

--
HTH...

Jim Thomlinson


"Pierre via OfficeKB.com" wrote:

Hi Jim,

you were right afterall !!!
Thanks,
Pierre

P.S. i now have the right code but now i see the "warning" sheet for a few
seconds when i start the application. is there a way to not see this sheet at
all when the application starts and the macros are not disabled?
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