Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Hiding excel tabs using macro
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Hiding excel tabs using macro
Resolved · Low Priority · Version 2007
Reply Wed 17 Aug 2011, 09:38Delegate Cristina said...
Cristina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Hiding excel tabs using macro
How do you hide tabs on excel and show only the file chosen on the user form?
For upcoming training course dates see: Pricing & availability
RE: Hiding excel tabs using macro
Right click on sheet tab and select hide from menu.
Reply Fri 19 Aug 2011, 15:12Delegate Cristina said...
RE: Hiding excel tabs using macro
Hi Rachael,
Thank you for your reply. However it sounds more like a "manual" command. did you mean I record the macro as I execute the above?
Cristina
RE: Hiding excel tabs using macro
Hi Cristina,
Yes, activate Macro and hide sheets and stop macro.
What exactly are you wanting to do? It this something you want your macro to perform each time you open excel, therefore creating a macro tool for this.
Maybe I need a bit more info.
Kind regards
Rachael
|