Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Howdee all.
Hope everyone had a great weekend. I'm looking to work through a series of workbooks that have numerous-- and I mean lots-- of hidden tabs. My goal is to xlveryhidden all hidden tabs, so that other users who don't have the need can't access a hidden tab. My initial thoughts on this have been- if worksheet.visibility = xlhidden then worksheet.visibility = xlveryhidden. My problem is that when I've tried this, it'd hang up, or give me an error. I'm sure that it's something real simple, but so far I haven't been able to make it work. And yes, I'd be using a for loop to work through all the hidden tabs in a given file. Thank you. Best. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sub Macro vrs Function Macro Auto Start | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Auto-run macro after auto-query refresh (Excel2000,sr1) | Excel Programming | |||
Macro Auto Run(2) | Excel Worksheet Functions | |||
Auto-run ONCE macro | Excel Programming |