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

[shiraz]

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

 

[Andrew Edwards]

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

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

 

[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