Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lost Menus & Toolbars with Right Click macro - HELP?
Hi
I want to 'disable right clicking' of the mouse in Excel and found the code below on the internet. I copied it into my workbook but now when I open Excel - any workbook (new or existing) I have no menu bar or toolbars (or right clicking which is what I wanted) only the formula bar. Please help?? Thanks and Merry Christmas. Silena Private Sub Workbook_Open() Application.CommandBars("Worksheet Menu Bar").Enabled = False Application.CommandBars("Cell").Enabled = False Application.CommandBars("Sheet").Enabled = False Application.CommandBars("Ply").Enabled = False Application.CommandBars("Row").Enabled = False Application.CommandBars("Column").Enabled = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.CommandBars("Worksheet Menu Bar").Enabled = True Application.CommandBars("Cell").Enabled = True Application.CommandBars("Sheet").Enabled = True Application.CommandBars("Ply").Enabled = True Application.CommandBars("Row").Enabled = True Application.CommandBars("Column").Enabled = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
How can I share custom Toolbars and Menus | Excel Discussion (Misc queries) | |||
Menus / Links associated with right-mouse-click lost! | Excel Discussion (Misc queries) | |||
Excel Menus/Toolbars missing | Excel Discussion (Misc queries) | |||
Missing menus and toolbars | Excel Discussion (Misc queries) |