Change workbook from readonly to compatiblity mode while in workbook

**rasikvekaria** · 09-27-2012, 11:05 AM

Dear Experts,

I always come across the problem where ive done loads of work on a workbook and when it comes round to saving it, i find out its read only. Is there any way i can run a macro so that the workbook changes from readonly to compatiblity mode or a way of basically runing a macro which does the process i have to do manually (i.e. saving the workbook as a copy, deleting the orignal, renaming the saved version) automatically.

Help would be great thanks.

Rasik

**HaHoBe** · 09-27-2012, 12:45 PM

Hi, Rasik,

try changing the read-only status like this:

Please Login or Register  to view this content.

Ciao,
Holger

**rasikvekaria** · 09-28-2012, 05:33 AM

Dear Holger,

This is doesn't seem to be working as im gettng a pop up notification saying file in use (is this because i am in the file)?

Rasik

**HaHoBe** · 09-28-2012, 02:12 PM

Hi, Rasik,

did you place the code into the workbook itself? I tested it from within the workbook opened as read-only, and it worked fine in Excl2010 under WinServer2003.

Ciao,
Holger

**rasikvekaria** · 10-01-2012, 04:26 AM

Dear Holger,

I have saved it as a personal macro... in the personal workbook is this the problem? I usually get this problem often so wanted to to work with any spreadsheet (that was readonly):

I have attached the picture below.
Untitled.jpg

Rasik

**HaHoBe** · 10-01-2012, 12:58 PM

Hi, Rasik ,

the code should work from any other workbook or addin as well but only if you alone do have the rights to do so. The message may indicate that some other user has opened the workbook and may edit it. This user may change the fileaccess. Maybe you try and find out if the workbook is free for opening before doing so.

Ciao,
Holger