Code needed

[cole7011]

is they a section of code, which can be used to hide some worksheet tabs but not others ??

and is they a way of hiding the toolbars in excel through code,

based on that i would simply place you code in to my macro thats made allready

thanks

 

[shades]

To hide sheets, by using worksheet name, include a line for sheet worksheet:

    Sheets("Source").Visible = False

If you want it more systematic, you can create a loop.

 

[Zack Barresse]

Yes, quite possible. A couple strong recommendations: 1) don't mess with toolbars too much, and 2) perform a board search. These issues have many answers for you on this board.

(Heya Shades!)

 

[cole7011]

include a line for sheet worksheet:


??

"sheet worksheet" ??

 

[shades]

include a line for sheet worksheet:


??

"sheet worksheet" ??

The tab is technically called a worksheet. There are at least two ways to reference them, by number, or by the name (the name on the tab). In this case it might be easier to use the worksheet names.

Thus, if your worksheets are named: Source, Work, Copier, House

And you want to hide all but house, then:

 Sheets("Source").Visible = False 
 Sheets("Work").Visible = False 
 Sheets("Copier").Visible = False

This will hide the three sheets/worksheets/tabs, and leave House as the only one showing.