Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code works fine . But the problem is i want to apply to only one
specific workbook . i.e this code it De-activates the Sheet menu bar in all the excel files i open ..... How to de-activate Menu bar in only one Excel Workbook ????????/ Say i want to Deactivate the Sheet toolbar in only Test.xls Workbook . Private Sub Workbook_Open() 'Application.CommandBars.FindControl(ID:=30026).En abled = True Dim Ctl As CommandBarControl On Error Resume Next For Each Ctl In Application.CommandBars.FindControl (ID:=30026).Controls Ctl.Enabled = False Next Ctl Application.CommandBars.FindControl(ID:=30006).Ena bled = True On Error GoTo 0 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do you activate the right click drop down menu in Excel? | Setting up and Configuration of Excel | |||
In Excel why does the / key activate the menu bar? | Excel Discussion (Misc queries) | |||
Workbook.Activate / Window.Activate problem | Excel Programming | |||
Deactive Activate Workbook Events - Add Menu | Excel Programming | |||
Excel VB, Workbook.activate | Excel Programming |