Open Workbook, Sheet Minimized VBA

**desk.doc** · 08-23-2007, 09:36 PM

Hi all. Using Excel 2003. I have a question about worksheets. In the single workbook I am creating, I want to have a workbook open and pull up a userform.(I can do this) What I am looking to do is have the worksheets hidden. I have read that you must have one worksheet visible in the workbook. Is there a way to minimize the only visible sheet through VBA? Thanks!

**Steven_Daniel** · 08-23-2007, 09:58 PM

Hi desk.doc

You cannot minimize worksheet tabs, but are able to minimize the window containing these tabs using the following.

Just create a code module and paste the following code samples into your VBA Editor.

VBA Code to minimize ActiveWindow containing Tabs

Please Login or Register  to view this content.

To hide all worksheets on the active worksheet, use the following.

Please Login or Register  to view this content.

To unhide hidden worksheets use the following
This code checks to see if the sheets are hidden, if so, it unhides them, otherwise, Hides them.

Please Login or Register  to view this content.

Hope this helps you out.

Cheers, :-)

**desk.doc** · 08-23-2007, 10:05 PM

Thank you Steven. Am I correct in thinking you have to have one of the sheets visible when you open the workbook?

**Steven_Daniel** · 08-23-2007, 10:11 PM

Hi Telton

Yes - you cannot hide all worksheets, one must be visible. Excel won't let you hide all worksheets.

Another way you can do this is to hide the worksheet tabs via the following

Please Login or Register  to view this content.

This will hide all worksheet tabs for the activesheet.

BTW: Users can also turn this back on via the Tools | Options menu option and clicking on Sheet Tabs to make them visible again.

Hope this helps

Cheers, :-)