Not show only unhidden screen ??

StanSz

Board Regular
Joined
Sep 18, 2004
Messages
199
I have a workbook where all the worksheets (except one saying that "Macros must be enabled...") are hidden at the Open.

The first command in the OnOpen macro is to unhide a "2nd" worksheet and with ScreenUpdating = True the desire is that this worksheet be displayed as soon as the workbook is opened.

What happens however, is that since this workbook is large (17MB) it takes a while for this "2nd" sheet to be made visible, and users are left with the "Macros must be enabled..." screen for a while even though they have in fact enabled macros.

Is there a way for nothing or just a blank screen to be displayed upon open rather than the "Macros" worksheet being displayed for a while ??

Thanks

StanSz
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Unless you want to set your users up with dual mega processors, I'd be happy that you can even open up a 17Mb workbook at all. :wink:

Can you pare it down a bit? (Dave Hawley @ www.ozgrid.com has some great suggestions for reducing file bloat.)

Smitty
 

Forum statistics

Threads
1,147,508
Messages
5,741,568
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top