MrExcel.com - Your One Stop for Excel Tips & Solutions

Make a column "xlVeryHidden"

Posted by David on January 28, 2002 11:20 AM

How can I make column A "xlVeryHidden"?

I tried columns(A,A)visable = xlVeryHidden
and it said the property was not supported.

Thanks in advance.

David

Posted by Tom Urtis on January 28, 2002 11:24 AM

Try something like this:

Sub HideSheet()
Sheets("Sheet2").Visible = xlSheetVeryHidden
End Sub

Posted by Juan Pablo G. on January 28, 2002 11:31 AM

Hide it, then protect the sheet. Also, one option, before you hide it, make its width to 0.15 or something like that, then hide it. You could also use a macro to determine everytime the activecell changes (SelectionChange()) if the column is hidden, and if not, hide it again.

Juan Pablo G.

Posted by David on January 28, 2002 11:33 AM

I need the sheet to be visible. I only want to hide column A. Is there a way to hide a column in VBA?

Thanks again.

Posted by Juan Pablo G. on January 28, 2002 11:33 AM

Columns(1).Hidden = True [NT]

Thanks again. : Try something like this

Posted by Tom Urtis on January 28, 2002 11:34 AM

Thanks Juan Pablo, I misread the question and answered for the entire sheet, not just for one column as he asked. :)

Tom U.

Posted by David on January 28, 2002 11:37 AM

How do I hide the column in VBA. Sorry, I'm a novice. I tried and got an error as mentioned before.

Thanks! Hide it, then protect the sheet. Also, one option, before you hide it, make its width to 0.15 or something like that, then hide it. You could also use a macro to determine everytime the activecell changes (SelectionChange()) if the column is hidden, and if not, hide it again. Juan Pablo G. : How can I make column A "xlVeryHidden"? : I tried columns(A,A)visable = xlVeryHidden

Posted by Juan Pablo G. on January 28, 2002 11:40 AM

See 18290a.html [NT]

Thanks! : Hide it, then protect the sheet. Also, one option, before you hide it, make its width to 0.15 or something like that, then hide it. You could also use a macro to determine everytime the activecell changes (SelectionChange()) if the column is hidden, and if not, hide it again. : Juan Pablo G.