Excel 2007

[IRoy]

Hi,
I have a problem with Excel when I want to share a file. Could somebody help me on the matter.



When I share the file the other users don't have the same format for printing than I and also the view is not the same.

When they open they see my hiden column and I don't know how to correct it.

[OTPM]

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

[macropod]

Hi IRoy,

If you hide a column no-one else can see it unless they unhide it. And that means they are reformatting your workbook - which also explains why the format is no longer what you gave them!

However, even if you hide a column it is still possible to select cells in it it (eg via Goto) and see what they contain. To prevent this:
• select the whole of your used range, then choose Format|Cells|Protection and check the 'hidden' option (the 'locked' option should already be checked)
• hide any rows/columns you don't want the users to be able to access - including rows/columns outside the used range.
• select the cells you want the users to be able to see and choose Format|Cells|Protection and uncheck the 'hidden' option for those cells only.
• select the cells you want the users to be able to edit and choose Format|Cells|Protection and uncheck the 'hidden' and 'locked' options for those cells only.
• choose Format|Protect Sheet and uncheck 'select locked cells'. You might also want to apply some of the other protection options. Then apply a password to your worksheet.