Hide Sheet Tab

[Andrew]

Dear All,
Could anyone show me how to write a macro to hide the sheets tab and also un-hiding them??

 

[Iridium]

Try recording the macro and see what code it generates

 

[Mudface]

Recording myself hiding and unhiding the tabs via the Options View menu (always the best way to find out), gave: -
<pre>
Sub Macro3()

ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.DisplayWorkbookTabs = True

End Sub
</pre>

 

[Von Pookie]

I'm a little confused. You don't need to use a macro do to this. You can just go to Format|Sheet|Hide (or unhide).

Basically, I'm just not certain if you're aware of that, or if you want a macro to do it for some other reason.

But hope it helps, anyway.

_________________<font color="#3399FF" size="3">Kristy</font>

This message was edited by Von Pookie on 2002-10-22 10:04

 

[Mark O'Brien]

To hide 'em, you can use:<pre>
ActiveWindow.DisplayWorkbookTabs = False</pre>

to make 'em visible again you can use:<pre> ActiveWindow.DisplayWorkbookTabs = True</pre>

OR, if you want to be a fancy pants using 1 button:<pre>
ActiveWindow.DisplayWorkbookTabs = Not(ActiveWindow.DisplayWorkbookTabs)</pre>

HTH

EDIT:: Mudface, I used the recorder as well
_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-10-22 10:05

 

[Mudface]

EDIT:: Mudface, I used the recorder as well

The recorder RULZ, D00D!

 

[Mark O'Brien]

I can see you've used the recorder at least 2 other times in that Excel session.

 

[Jack in the UK]

To add

its worth remembering you mush have one tab showing at all times regardless, BUT you can hide that oone by un tick tools options tabs,

If you hide all in VBE and write the code it will fault!!

Jack

 

[Locolobo1]

How about trying this:

Sheets("SheetName").Visible = False

You can place it in a macro or a control (button).