View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ileiry Ileiry is offline
external usenet poster
 
Posts: 3
Default 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