#1
|
|||
|
|||
Excel 2007
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. |
#2
|
|||
|
|||
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 |
#3
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2007 to Outlook 2007 - task import possible? | mjwillyone | Outlook | 2 | 07-05-2023 07:23 AM |
Excel 2007 cell format help!!! | Raner | Excel | 4 | 06-17-2013 11:13 PM |
Excel 2007 to Word 2007 Labels mail merge not working | rec | Mail Merge | 0 | 07-31-2010 10:45 AM |
Error Bars Excel 2007 | arthos8 | Excel | 1 | 01-30-2010 12:27 PM |
Example req for VBA app in excel 2007 (for Office 2007) | aligahk06 | Excel | 0 | 08-28-2009 04:36 AM |