Enter modify password after opened

[plimoman]

I have a few Excel files that I configured with a read-only and different write access passwords. I was wondering if there is a way to go from read-only to write mode while the file is open, instead of having to close the file, reopen enter the main password then enter the password for write access. It would be nice to go from read-only to write so I can make the changes needed and return to read-only.

 

[GWteB]

In general it could be done with VBA, however, when a file is ReadOnly, Excel (also) needs to close the file and to open it afterwards.
Besides that Excel can crash due to memory issues, despite the fact that there is more than enough memory.
The code below is in a 21 KB file on a machine with 16 GB of memory (2.3 in use), still Excell (2013, 32 bits) argues about not enough available memory.

Sub Example()
    With ThisWorkbook
        If .ReadOnly Then
            .ChangeFileAccess xlReadWrite
        Else
            .ChangeFileAccess xlReadOnly
        End If
    End With
End Sub

 

[plimoman]

Thank you for the reply. I guess since its not as simple as I would of hoped I will stop being lazy and just close and reopen.

In general it could be done with VBA, however, when a file is ReadOnly, Excel (also) needs to close the file and to open it afterwards.
Besides that Excel can crash due to memory issues, despite the fact that there is more than enough memory.
The code below is in a 21 KB file on a machine with 16 GB of memory (2.3 in use), still Excell (2013, 32 bits) argues about not enough available memory.

Sub Example()
    With ThisWorkbook
        If .ReadOnly Then
            .ChangeFileAccess xlReadWrite
        Else
            .ChangeFileAccess xlReadOnly
        End If
    End With
End Sub

 

[Legacy 456129]

Could work with a Personal.xlsb containing the macro, password protected of course. The file is always loaded as the very first thing of launching Excel. Read at.

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Got one permanetly loading a custom ribbon with 2 dozen or so custom buttons with assigned macros, plus it executes some stuff to set up the environment.