How to hide a column

[Pascale]

Hello,

I want to send out an excel file to some people, but I dont want them to see
the column c. I know how to hide a column, That is not what I need, I need
to have this column not accessible at all by the people who will receive this
file.

Is this possible?


Thank you Pascale

 

[Don Guillett]

Hide by code using xlVERYHIDDEN. Then it can only be unhidden by code.
Protect the code

 

[Pascale]

Very good and how do I get this to work?

Hide by code using xlVERYHIDDEN. Then it can only be unhidden by code.
Protect the code

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Sub veryhidecol()
Columns(3).Hidden = xlVeryHidden
'uncomment line below to view
'Columns(3).Hidden = False
End Sub

 

[Gord Dibben]

If it is imperative that the recipients do not see the data in column C do not
include column C when you send the workbook.

No matter what you do to hide and protect the column. it can be unhidden by
someone determined to get a look.


Gord Dibben MS Excel MVP