Allow resize Columns/Rows and disable hide/unhide

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.