Prevent other users seeing hidden columns/data
 

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

Prevent other users seeing hidden columns/data
 

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.
--
David Biddulph

"Mouettes" wrote in message
...
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

Prevent other users seeing hidden columns/data
 

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

"Mouettes" wrote:

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

Prevent other users seeing hidden columns/data
 

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

"Mouettes" wrote:

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