Hi,

Also, is there a way to make a column in a worksheet "VeryHidden", similar to a very hidden worksheet through visual basic?

Thanks:)

Hi, nh1234,

not to my knowledge.

Ciao,
Holger

It can't be very hidden:

A B C E F will get spotted anyway.

However you can 'not show' row & column headers (I'm not a fan of this) and protect the sheet.
Not great because the user can just show the headers if needed

You can also just put the data onto a Very Hidden Sheet.

I'm not sure what "Very Hidden" means, but you can hide a worksheet by highlighting its tab and going to the Format menu, Worksheet-Hide.

Is this what you're looking for?

http://j-walk.com/ss/excel/usertips/tip036.htm

Hi, vangogh228,

reading the thread carefully before posting could help to find the answer (which should be no: not for columns on a worksheet)... ;)

Ciao,
Holger

Thank you, Mr. Sarcasm. That was very helpful.