Ask Your Question

Revision history [back]

Recording a macro to hide cells works for me and the macro hides the cells. A sample is here Hide.ods

You should be aware though that the cells will not be hidden until you protect the sheet. It states in the Cell Protection Tab in Format Cells that "Cell Protection is only effective after the current sheet has been protected".

If you run the macro in my sample the cells are not hidden. When you protect the sheet they become hidden.
The macro in my sample was recorded and no modifications made.