Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent User Seeing Data in Hidden Columns | Excel Discussion (Misc queries) | |||
Prevent wandering users | Excel Discussion (Misc queries) | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
How do I prevent hidden columns from being revealed by another use | Excel Discussion (Misc queries) |