hiding protected cells

[macro_panic]

i have a macro which hides certain columns. i need to protect/lock some cells in these columns, but excel won't let me hide protected cells. is there a way of hiding columns which contain protected cells, please? thanks in advance!

 

[shades]

I just tried it without any macro (manually protecting the cell, then hiding the column) and it worked fine (Excel 97).

Maybe the problem is in the macro?

_________________
- old, slow, and confused
... but at least I'm inconsistent -
This message was edited by shades on 2002-03-28 07:21