disable the worksheet read only temporaily in VBA

  • Thread starter Thread starter Grey
  • Start date Start date
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
 
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
 
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
 
Back
Top