Read & Write Access

[SgtPepps]

Is there a way of having an xls open with read only access and then have the rights changed to write access with vba?

 

[Loomah]

Hellooooooo Sarge
I was about to give up on this as not possible or leave it to someone wot is clevva. But then I came up with this!

Sub WriteAccess()
ThisWorkbook.ChangeFileAccess xlReadWrite
End Sub

It will ask you if you want to open your book as read onlly in the same way that happens when you open the file in the first place.

;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[SgtPepps]

simple as that, cheers!