Disable Save As dialog on ReadOnly spreadsheet

A

Andy

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
 
K

Kanan

it definitely should be in auto_close. also the beforesave event in the workbook
event.
hope this helps
kanan
 
Top