View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 1
Default Disable Save As dialog on ReadOnly spreadsheet

Hi All,
How can I disable the Save As prompt from appearing in a Read Only
spreadsheet?

something along the lines of (pseudo code)

if workbook.readonly then
close the workbook without saving
else
save the changes
end

What event should any code be put in ?

Andy