How to hide a column
 

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

How to hide a column
 

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

How to hide a column
 

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

How to hide a column
 

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

How to hide a column
 

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