how can I hide a column that can't be unhidden in a email

S

shiraz

How an I hide a column so that when I email the workbook, that column cannot
be seen or unhidden by the recipient?
 
A

Andrew Edwards

shiraz said:
How an I hide a column so that when I email the workbook, that column cannot
be seen or unhidden by the recipient?
Click to expand...

Assuming the column in question is column "C" in Sheet1:

1) Right Click on the Sheet1 Tab and choose "View Code"
2) Type the following:

Private Sub hideColumn()
Worksheets("Sheet1").Columns("C").Hidden = True
End Sub

3) Run the macro

That should do the trick.

Regards,
Andrew
 
J

JE McGimpsey

One way:

Hide the column then choose Tools/Protection/Protect Sheet and enter a
password.

HOWEVER, this protection can be bypassed in a heartbeat by anyone with
the ability to find these groups or do a Google search. If you don't
want someone to see what's in your workbook, send them a pdf.

See: http://www.mcgimpsey.com/excel/removepwords.html
 
Top