hiding protected cells

macro_panic · Mar 28th, 2002, 07:41 AM

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 · Mar 28th, 2002, 08:20 AM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 07:41 AM	#1
macro_panic New Member Join Date: Mar 2002 Posts: 47	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!

Mar 28th, 2002, 08:20 AM	#2
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	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 ]