View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Disable message box when trying to save a read only workbook

I am a little confused as to why you would click the save button on a read
only file. There should be nothing to save since no changes can be made,
unless you want to save it under a different name, in which case, the pop up
message is appropriate.

"AR" wrote:

Is it possible to disable the message box that appears when I click the save
button in a read only workbook (€œabcWorkbook.xls is read only. To save a
copy, click OK, then give the workbook a new name in Save As dialog box€)

I have disabled the Save As dialog in the Workbook_BeforeSave() event and am
displaying a customized message.

--
Thanks,
Amrit