Avatar of AndresHernando
AndresHernando
 asked on

Excel VBA - how to hide the Ribbon

How can I hide the ribbon for one particular worksheet?

I want to automatically hide the ribbon when that worksheet is selected.

Thanks, --Andres
Microsoft Excel

Avatar of undefined
Last Comment
AndresHernando

8/22/2022 - Mon
zorvek (Kevin Jones)

This will toggle it:

   Application.DisplayFullScreen = Not Application.DisplayFullScreen

Kevin
ASKER CERTIFIED SOLUTION
zorvek (Kevin Jones)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
AndresHernando

ASKER
Worked great!   THANKS Kevin!!!   --Andres
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck