Allow resize Columns/Rows and disable hide/unhide

Protecting the Sheet, does just that.

To disable the Hide/Unhide you need to click on Protect Workbook. This has different privileges associated with it. You only need to enter the password for that one.

I would recommend setting all your sheet protection options first for all the sheets you want to protect, then apply the Workbook protection.

I think that is what you are asking for.

I have just been looking at it a bit more, and what you are saying is that you want to be able to stop people from being able to hide/unhide rows and/or columns as apposed to sheets.

I have just realised that what I have suggested would not help to do that. However there might be another way to do what you want to do.

The best way to I can think to do this is with formatting of the cells you want to protect. I've attached some screen grabs to make it a bit easier to follow.

Select the columns/rows/cells you want to hide (conceal).
Attachment 439868

Format it with the same colour text as the fill
Attachment 439869

Next right click the colums/rows/cells you want to protect and right click, the select Format Cells.
Attachment 439870

Now make sure that you have the Locked box ticked (if you want to hide formulas the is where to do it with the hidden box. (By default they will be locked, so for all other columns/rows/cells, you will need to untick the locked box.
Attachment 439872

Right click again and now select hide.
Attachment 439873

Finally, click on the Review tab of the ribbon, click Protect Sheet, set your password and untick select Locked cells, and tick format columns/rows/cells as required.

I'll attach a sample on the next post.

Please find the sample attached to this post.

I think I understand.

However putting aside the formatting part, you should still be able to protect your headers from being deleted/hidden using the Lock/unlock and applying to the header row. With that you cannot select the column/row, if you can't select it, you can't delete it.

Once this is done the Columns can still be edited, rows/columns can still be inserted but the header row cannot removed/hidden. The only exception is if any of the rows above are not locked, then a person could select across them and hide them. Once protected the cells cannot be deleted.

The VB you have entered is for autofit and does not effect or is even related to showing/hiding columns, so based on that I'm assuming you are referring to using the VB code whilst using protected without selecting the format columns option in the protection selection window.

I am I any closer? (See the attached).