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

Disable Save As dialog on ReadOnly spreadsheet
 

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

"Andy" wrote:

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