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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pascale" wrote in message
...
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

Very good and how do I get this to work?

"Don Guillett" wrote:


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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pascale" wrote in message
...
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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pascale" wrote in message
...
Very good and how do I get this to work?

"Don Guillett" wrote:


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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pascale" wrote in message
...
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

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

On Wed, 27 Feb 2008 06:44:08 -0800, Pascale
wrote:

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