Disable Save As dialog on ReadOnly spreadsheet

[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

 

[Guest]

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