Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can I hide a column that can't be unhidden in a email
How an I hide a column so that when I email the workbook, that column cannot
be seen or unhidden by the recipient? |
#2
|
|||
|
|||
shiraz wrote:
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 |
#3
|
|||
|
|||
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 In article , shiraz wrote: How an I hide a column so that when I email the workbook, that column cannot be seen or unhidden by the recipient? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide column but show chart | Charts and Charting in Excel | |||
How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
hide column | New Users to Excel | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |