VBA to Hide columns

[Malhotra Rahul]

Hi, I have a worksheet tab "Report" in which i want to hide entire columns from AI to ZZ, since there are workings in those columns and i have to keep unprotect the worksheet as well.

Is there any way where i can hide the said columns so the user can not unhide those columns in any manner not even by right click and double click.

Any help would highly be appreciated. Thank you in Advance.

 

[Cornejo]

You may be able to achieve this if you lock/protect only those columns. Try this:

Select all cells
Right Click (for the menu)
Format Cells
Protection
Then uncheck the "Locked" box.

Now, to lock the specific cells. Follow the same steps as above with one exception. In the final step, CHECK the "Locked" box. Then hide the columns.

From here, you should be able to protect the worksheet. The user(s) will be able to manipulate every other cell, EXCEPT the cells you "Locked".

 

[Malhotra Rahul]

You may be able to achieve this if you lock/protect only those columns. Try this:

Select all cells
Right Click (for the menu)
Format Cells
Protection
Then uncheck the "Locked" box.

Now, to lock the specific cells. Follow the same steps as above with one exception. In the final step, CHECK the "Locked" box. Then hide the columns.

From here, you should be able to protect the worksheet. The user(s) will be able to manipulate every other cell, EXCEPT the cells you "Locked".

Hi Cornejo, Thank you so much for your support but I am looking for through VBA this part and the reason is I have to keep the the whole worksheet as unprotected.

 

[Joe4]

the reason is I have to keep the the whole worksheet as unprotected

Why? You can protect just certain parts of the sheet, so that they would have access to update and save other things.
Because what you are really asking to do is to "protect" certain parts of the sheets.

The issue with VBA code is that they could simply open the workbook with VBA disabled, and easily beat that strategy.