making the worksheet menu bar not visible

  • Thread starter Thread starter matt dunbar
  • Start date Start date
M

matt dunbar

hi

because i have provided all relevant functions for my excel files as
button macro's i have therefore set all command bars as visible = false
in an "Open" macro

is it possible to also make the worksheet menu bar not visisble upon
opening a file - essentially making the Excel screen appear white except
for the application bar at the top and the open applications windows at
the bottom of the screen

also how would i make it visible again as part of the Before Close
macro?

thanks

matt
 
Hi Matt,

Application.Commandbars("Worksheet Menu Bar").Enabled = False

Set it to True at the end

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

hi

because i have provided all relevant functions for my excel files as
button macro's i have therefore set all command bars as visible = false
in an "Open" macro

is it possible to also make the worksheet menu bar not visisble upon
opening a file - essentially making the Excel screen appear white except
for the application bar at the top and the open applications windows at
the bottom of the screen

also how would i make it visible again as part of the Before Close
macro?

thanks

matt
 
Back
Top