force enable macros lag

Hey
I have a book SIMILAR to this 1
and when you open it it kinda lags
and you get a flash of the welcome screen
any ideas how to stop this?
I know its not a major thing but its more aesthetic than functional.
and i want this to look GOOD :D

There are two macros running in this workbook. The first (Workbook_Open) runs first thing after the workbook opens. The second (Workbook_BeforeClose) runs just before you exit. The flash screen is just another worksheet which is hidden using the xlveryhidden property. To correct this, you need to

Alt+F11 to open the VBE
Cntl+G to view and set focus on the Immediate Window
Type This
worksheets("Enable Macros!").visible = true and press Enter.
worksheets("Data").visible = true and press Enter.


You also need to remove the code from Thisworkbook or else it will rehide everything before it closes.


Hope this helps

oh no i dont want to know how to show/hid the sheet
i just want the LITTLE flash of the enable macros! sheet to stop
i dont know if this is possible

You can only alter this by altering your own security settings - this is specific to each client and can't be controlled using VBA (given that would defeat the purpose of security settings in the first instance)

oh ok
thanks anyway guys

I don't get the flash using this code, and it's more flexible than the existing code.

Apologies all - notably Friel - I interpreted "Enable Macros" in your narrative as being the default Security Dialog - my bad.