Stopping Excel from opening in Read Only from Sharepoint.

[Grizlore]

Hi All,

Any help appreciated

I have a Excel file, which contains VBA, Userforms etc - everything works fine....

However when anyone opens it, as it sits on SharePoint (I think that is why it does it) it opens in read only and you have to click the "Edit Workbook" button in the ribbon.

Can this be manually done with some VBA code? It would save me a lot of bother and make the current code work a lot better.

Thanks for any help in anticipation

 

[mole999]

read here > https://sharepoint.stackexchange.co...ead-only-mode-how-to-change-this-to-edit-mode

 

[Grizlore]

Thanks - doesn't seem to be stopping it