disable the worksheet read only temporaily in VBA

G

Grey

Dear all

I have set the worksheet to read only mode. I want to know that how to disable this mode to cell editable mode while I need to updated some cells through VBA.

Best Regards,

Eric
 
R

Rob van Gelder

Eric,

Sheet1.Unprotect

Rob

Dear all

I have set the worksheet to read only mode. I want to know that how to disable this mode to cell editable mode while I need to updated some cells through VBA.

Best Regards,

Eric
 
J

John Wilson

Grey,

From the VBA editor (Alt + F11) and the Immediate Window (Ctrl + G)
or via VBA code:

thisworkbook.ChangeFileAccess xlReadwrite

John
Dear all

I have set the worksheet to read only mode. I want to know that how to disable this mode to cell editable mode while I need to updated some cells through VBA.

Best Regards,

Eric
 
Top