macro to disable/enable read only

**thoandros** · 04-12-2018, 10:51 AM

Hello
I have an excel file which is password protected for modification. I do know the password however I often prefer to open it as read only, since I need to format tables and columns and use filters, to avoid the risk to save it over by mistake.

However, it could be that sometimes I am on read-only mode but I realise I want to save the changes I just did, and of course I cannot, so I need to close the file, open it again with the password and re-do all the changes. Save. Close again and re open as read only.

I wonder if there is a way to have a macro that I can launch whilst on read-only mode that temporarily disable the read-only mode, save the file, puts back the read only mode (password protected).

I found the below code but it does not save the file back as read-only

Please Login or Register  to view this content.

Anyone that can help me on this?
thanks everyone

**alansidman** · 04-12-2018, 10:54 AM

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

**dominicb** · 04-12-2018, 11:20 AM

Good afternoon thoandros

Originally Posted by thoandros

I wonder if there is a way to have a macro that I can launch whilst on read-only mode that temporarily disable the read-only mode, save the file, puts back the read only mode (password protected).

I don't think so.

When you open a file in read-only mode, you can use Save As - but it needs to be a different file name. Add a 1 (or any character to the file name). When you've finished, delete the original file, and remove the extra character from the newly saved file.

Sure, it's a bit of a faff, but it works, and it's probably quicker than what you do now.

HTH

DominicB

**thoandros** · 04-12-2018, 11:38 AM

Hi,
I cannot do that because loads of other files have references to this this file.

**dominicb** · 04-12-2018, 11:52 AM

Hi thoandros

Are they all open at the same time your read-only file is open?
If they are then you cannot do this and you will have to revert back to doing it your old way.*
If they are not, then it's irrelevant - the file name will not change, and the next time they are opened will read from the new file.

* Try this with copied files (not the originals, till you get the hang of it

), but you could turn off automatic calculation, perform the steps I describe, then switch back to automatic calculation. In theory, this should work.

HTH

DominicB

macro to disable/enable read only

LinkBack

Thread Tools

Rate This Thread

Display

macro to disable/enable read only

Re: macro to disable/enable read only

Re: macro to disable/enable read only

Re: macro to disable/enable read only

Re: macro to disable/enable read only

Thread Information

Users Browsing this Thread

Similar Threads

Getting rid of Enable/Disable Macro prompt on launch

Stopping Disable/Enable Macro Message

enable and disable macro

enable/disable macro

[SOLVED] Macro Enable/Disable

disable and enable macro execution using VBA in another workbook?

[SOLVED] Enable - Disable Macro Dialog Box

Bookmarks

Bookmarks

Posting Permissions