ExcelBanter - disable the worksheet read only temporaily in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - disable the worksheet read only temporaily in VBA (https://www.excelbanter.com/excel-programming/287443-disable-worksheet-read-only-temporaily-vba.html)

Grey

disable the worksheet read only temporaily in VBA

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

Rob van Gelder[_4_]

disable the worksheet read only temporaily in VBA

Eric,

Sheet1.Unprotect

Rob

"Grey" wrote in message ...
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

John Wilson

disable the worksheet read only temporaily in VBA

Grey,

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

thisworkbook.ChangeFileAccess xlReadwrite

John
"Grey" wrote in message ...
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

All times are GMT +1. The time now is 10:30 PM.