Hiding Spreadsheets

[bopo]

Hiya

Basically when a double click on the excel exe icon, I want all the worksheets to be hidden (not viewable) how to I do this?

[Bob Phillips]

You can't. At least one worksheet must be visible.

You could hide the window



Windows("myBook.xls").Visible = False

[bopo]

Oh well, but how do I remove tabs at the bottom of the worksheet?

[johnske]

with code... ActiveWindow.DisplayWorkbookTabs = False

[johnske]

There's another alternative in post #8 here > http://www.vbaexpress.com/forum/showthread.php?t=10358

[Charlize]

Oh well, but how do I remove tabs at the bottom of the worksheet?
link to vbax thread : http://vbaexpress.com/forum/showthread.php?t=10994

Charlize