Thread: Hiding Tab with automatically changing tab name

Hi all,

Wondering if someone can help me. I am having a few problems with hiding certain tabs. I have 10 + tabs in the workbook I want the VBA code to select all tabs after the first 3, so they can be hidden / unhidden using a radio or button.

The name of the tab changes automatically based on values within a certain cell hindering me from using a constant name.

I am very new to VBA code and mostly copy so any examples would be greatly appreciated

HI

Try using code like this to hide

dim a as integer
for a = 4 to worksheets.count
sheets(a).visible=xlveryhidden
next a

and to show

dim a as integer
for a = 4 to worksheets.count
sheets(a).visible=true
next a

Regards

Jeff

Hi mate,

Thanks for the reply but it doesnt seem to work. Is sheet 1 or 4 supposed to be named as "a"?

Sweet all works now

Thanks for all the help