Hello;

I'm trying to protect/hide the formulas on a w/s by protecting the w/s so
that I may not accidentally delete or overwrite them.
It works fine with the exception that the Hide & Unhide column no longer
available either via Format::Column::Hide and Unhide or by a macro.

The macro to hide / unhide columns produces:
Run-time error '1004':
"Unable to set the Hidden property of the Range class"
and in the macro code:
......Range("J1:K1").Select
....Selection.EntireColumn.Hidden = True is highlighted

Is there a workaround this difficulty; namely protecting the w/s formulas
and still be able to Hide / Unhide columns ??

Thank you kindly.