ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hidding Tabs (https://www.excelbanter.com/excel-discussion-misc-queries/1941-hidding-tabs.html)

Aviator

Hidding Tabs
 
I know that this sounds easy and maybe it is. I need to be able to hide
specific tabs (which I can do). The problem is that I also need to be able to
get to these tabs through a macro "button". Currently, I can go back and
forth with these macro "buttons". But only when the tabs are unhiden. Once I
hide the tabs I can no longer macro over to them.

How can I have the specific tabs hidden and still be able to macro in & out
of them?

Frank Kabel

Hi
in your macro you first have to unhide the specific sheet

--
Regards
Frank Kabel
Frankfurt, Germany
"Aviator" schrieb im Newsbeitrag
...
I know that this sounds easy and maybe it is. I need to be able to hide
specific tabs (which I can do). The problem is that I also need to be able
to
get to these tabs through a macro "button". Currently, I can go back and
forth with these macro "buttons". But only when the tabs are unhiden. Once
I
hide the tabs I can no longer macro over to them.

How can I have the specific tabs hidden and still be able to macro in &
out
of them?





All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com