Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiden tabs & macros
Can you hide tabs and still run macros?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiden tabs & macros
You can hide worksheets and still have a macro which accesses data on that
sheet, if that's what you mean. You can not hide all sheets, there must be one visible, though if you create a userform, you could resize the visible sheet to hide it behind the form. If this doesn't answer your question, please explain your requirements further. -- Ian -- "PG" wrote in message ... Can you hide tabs and still run macros? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiden tabs & macros
Yep (in the vast majority of cases).
Remember to not select the worksheet or a range on that sheet or any shape on that sheet, though. There are a few things that have to have the sheet selected to work--but I'd bet you wouldn't be using them in a hidden sheet anyway. If you're having trouble tweaking your code, post back with your specific question. PG wrote: Can you hide tabs and still run macros? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running macros on ALL Excel tabs | Excel Worksheet Functions | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) |