Save Read Only File

[Kevsim]

I have an Excel worksheet that opens as Read Only, I wish to do the following.
There is a command button on the spreadsheet, that when pressed updates the spreadsheet, I wish to have VB code for when the spreadsheet updates, it will auto save the update.
I would appreciate your assistance.
kevsim

 

[VBAjedi]

Not entirely sure what you are asking for. If all you are trying to do is save the current workbook using VBA, the code would be:

ActiveWorkbook.Save

which could certainly be called within the code that updates the sheet.

VBAjedi

 

[PHV]

VBAjedi, have you tried to save a workbook opened ReadOnly ?

 

[RoyVidar]

If macros are enabled, shouldn't one be able to do the following?

[tt]activeworkbook.saveas "c:\newname.xls"[/tt]

Roy-Vidar

 

[PHV]

Roy, the OP asked for it will auto save the update and I don't think he wanted a new workbook.

 

[RoyVidar]

Yup - so now there are two alternatives - give it up (or not open as read only) or save as a new file/workbook...

Roy-Vidar