View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimN TimN is offline
external usenet poster
 
Posts: 72
Default What am I doing wrong?

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?