I have written an macro to save the contents of the excel
sheet into a database whenever the SAVE is clicked in the
standard command bar. If the excel template is a read only
one, when the save is clicked excel gives a message "
Template is read only choose a different name to save"
after "OKying" it performs the macro that i have written.
Is there anyway to suppress that message. I even tried

Application.displayalerts=false but still the message
appears.