disabling toolbars

[isma786]

I have an excel sheet that have specified user input cells and one button to print and another to exit. I have managed to un-enable the view of toolbars but how do you disable the main dropdowns?

 

[TonyJollans]

Hi isma786,

Not entirely sure what you're asking, but take a look at FAQ707-4841. You should find help in there.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[ChrisBurch]

Hi isma786,

You have to use vba to do this. As a starting point try the following code, calling the disable sub from the workbook on open event, and the disable routine from the before close event. It would probably be a good idea to call them from a couple of buttons, before you set them up to be auto, just to be sure that they are doing what you wanted.

Sub DisableAllShortcutMenus()

CommandBars("Toolbar List").Enabled = False
CommandBars("Worksheet Menu Bar").Enabled = False
CommandBars("System").Enabled = False
CommandBars("Standard").Visible = False
CommandBars("Formatting").Visible = False

End Sub

Sub EnableAllShortcutMenus()

CommandBars("Toolbar List").Enabled = True
CommandBars("Worksheet Menu Bar").Enabled = True
CommandBars("System").Enabled = True
CommandBars("Standard").Visible = True
CommandBars("Formatting").Visible = True


End Sub

Chris

IT would be the perfect job......if it didn't have users!!!