Prevent people from hiding cells in Excel

[saraapple]

I have a spreadsheet I need to share and allow people to edit - However I need them to stop hiding cells as it is causing big problems later on as not everyone knows how to unhide them and mistakes are being made.
Is there a way to prevent users hiding cells in excel but still make other edits?

 

[Yongle]

It depends what else they need to do, but I think you can do what you need by protecting the sheet

1. Select ALL cells in worksheet \ right-click\ format cells \ protection \ unlock cells \ ok
2. right-click on sheet tab \ Protect Sheet \ scroll to the bottom (2 pages) and make sure EVERYTHING is ticked EXCEPT Format Columns and Format Rows
3. add a password and protect

This prevents rows and columns from being hidden but allows them to be deleted etc

VBA is your likely solution if, for any reason, above does not do what you require