Change excel workbook to read only while in workbook

[rasikvekaria]

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

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.