Thread: [Solved] Excel 2007
View Single Post
 
Old 04-28-2011, 02:09 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Sharing Excel Workbooks

Hi
Firstly I am not sure why you dont want others to see your hidden column. However what you could do as a quick and dirty solution is as follows:
1. On your active worksheet "unprotect" all cells on the worksheet.
2. Select the column you dont want other to see when you share it and change the font colour to white.
3. Whilst this column is still selected choose the option to protect those cells.
4. Then protect the worksheet with a password. This will have the ffect of stopping shared users seeing what is in the protected column and also from changing anything. They will still se the column but cannot read it.
5. WHen you want to change anything in that shared column, unshare the workbook, make the changes, and then repeat the steps above.
Hope this helps.
Kind regards
TKHussar
Reply With Quote