View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Disable Saveas Dialog

In the before save event, if SaveAsUI is true, then set cancel = True
Perhaps putting up a message box saying this is not allowed.

--
Regards,
Tom Ogilvy


"VJ" wrote in message
...
Is there any way I can't show the Saveas Dialog box through vba code?