Lock Columns except some cells

[Xirom431]

Hi,

I have a workbook with all sheets have the same info. I would like to lock and hidden all sheet columns A to Y except cells Range from J5:N51 and P5:X51. Protect all formulas. Thank you for the help in advance with the vba macro.

Thanks,

XR

 

[Anfinsen]

Hi,

I have a workbook with all sheets have the same info. I would like to lock and hidden all sheet columns A to Y except cells Range from J5:N51 and P5:X51. Protect all formulas. Thank you for the help in advance with the vba macro.

Thanks,

XR

Hello,
Fiirst, you need to format the 2 cell ranges, as "Unlocked".
Then click Review, Protect Sheet, and click the "Select Unlocked Cells" option.

In your VBA code, you can write your code between these 2 statements, and it will lock and unlock the cells so it can perofrm your code.

Activesheet.Unprotect
Activesheet.Protect

 

[Joe4]

Note that if you turn on the Macro Recorder and record yourself performing these steps manually, you will get most (if not all) the VBA code you need to do this.

 

[Anfinsen]

Note that if you turn on the Macro Recorder and record yourself performing these steps manually, you will get most (if not all) the VBA code you need to do this.

Joe,
you are the man, just wanted you to know that

 

[Xirom431]

Note that if you turn on the Macro Recorder and record yourself performing these steps manually, you will get most (if not all) the VBA code you need to do this.

Thanks for the advice and it works well.