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
|