Prevent other users seeing hidden columns/data

[Mouettes]

Hi,

I want to 'hide' a column of data in an Excel spreadsheet... attached the
file and email to another user. However, when they open it I want to prevent
them from 'unhiding' the column. How is this achieved. I am using Excel
2002.

Many thanks

 

[David Biddulph]

You could protect the worksheet (with a password to unprotect).
The password is relatively easy to crack, but it puts a slight obstacle in
the way.

 

[Ileiry]

Solution might be to put those data/columns in a different worksheet, then
open the visual basic editor (under tools/macros), and in the lower left
properties where it says visible, set it to 2 - xlsheetVeryHidden
To see the sheet again, repeat process and set the visble property to -1
xlsheetVisible

 

[Ileiry]

solution might be to put these columns in a different sheet, open the visual
basic editor and set the visible property (on the lower left pane) to 2-
XlsheetVeryHidden
set it back to -1 - XlsheetVisible to restore to normal