Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following code that will disable the File \ Save As function on
the tool bar: Private Sub Workbook_Activate() Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=748, Recursive:=True).Enabled = False End Sub The problem is when I close this workbook and open a different one, my File \ Save As is disabled there also. I thought the VBA code would only impact the workbook in which it was written. What am I missing? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
i did something wrong | Excel Discussion (Misc queries) | |||
Min Max What's Wrong? | Excel Worksheet Functions | |||
Getting wrong value due to ref? | Excel Discussion (Misc queries) | |||
what am i doing wrong | Excel Programming |