View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrianG[_4_] BrianG[_4_] is offline
external usenet poster
 
Posts: 23
Default Disable File-Save menu item in macro?

Thanks. I use the ActiveWorkbook.SaveAs method to save the file to the
server and discovered that the BeforeSave event is triggered by this
method. Is temporarily disabling events using the
Application.EnableEvent property the best way of dealing with this?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!