PDA

View Full Version : Hiding Spreadsheets



bopo
01-16-2007, 05:55 PM
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?

xld
01-16-2007, 06:20 PM
You can't. At least one worksheet must be visible.

You could hide the window



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

bopo
01-16-2007, 07:40 PM
Oh well, but how do I remove tabs at the bottom of the worksheet?

johnske
01-16-2007, 08:06 PM
with code... ActiveWindow.DisplayWorkbookTabs = False

johnske
01-16-2007, 09:31 PM
There's another alternative in post #8 here > http://www.vbaexpress.com/forum/showthread.php?t=10358

Charlize
01-17-2007, 02:03 AM
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