Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Hiding excel tabs using macro

Hiding excel tabs using macro

ResolvedVersion 2007

Wed 17 Aug 2011, 09:38 Delegate 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:41 Trainer Rachael said...

RE: Hiding excel tabs using macro

Right click on sheet tab and select hide from menu.

Fri 19 Aug 2011, 15:12 Delegate 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:50 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips

Hiding excel tabs using macro

Hiding excel tabs using macro

RE: Hiding excel tabs using macro

RE: Hiding excel tabs using macro

RE: Hiding excel tabs using macro

Excel articles

Excel tip:

Shortcut for accessing recently opened files