98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Hiding excel tabs using macro
Hiding excel tabs using macro
Resolved · Low Priority · Version 2007
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?
Wed 17 Aug 2011, 18:41Trainer Rachael said...
RE: Hiding excel tabs using macro
Right click on sheet tab and select hide from menu.
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
Sat 20 Aug 2011, 19:50Trainer Rachael said...
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
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. |
Excel tip:The Easiest and Quickest Way to use Autosum in Excel 2010Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature. |
