Saving Macro + Read Only?

[Dysprositos]

Hello to anyone who can help me out.

Ive written a macro to save the file, keeping the previous filename. How can i disable the message
"A file named C:Documents...Workbook.xls already exists in this location. Do you want to replace it?"

I know the file has been changed, and id like to save it without being told that its changed.


ALSO... What have i done to cause this workbook to be read only as default? (its not the rightclick properties either)

THANKS!!

 

[Dragracer]

To clear the read only. Do a SaveAs, click the Tools | Options button on the SaveAs dialog, and clear
the "Read-Only Recommended" check box.

To save you file with the message change your code to

ThisWorkbook.Save

You are probably using the SaveAs command.

 

[Dysprositos]

Cheers!