Hide the cell reference call

[kbka]

Hi!

I have an excel workbook with different users for different sheets as described here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=380


Now, I would like to use some references across the worksheets. So that some cells in sheet1 are visible in sheet2 using a reference call. e.g =sheet1!A1

However, some of the data in sheet1 must not be visible in sheet2. lets say column B in sheet1. I would like to "hide" the reference, so that the user of sheet2 can not see the name of the hidden sheet by clicking the cells with reference to sheet1!A1. So only the value of the reference should be visible.
The reason for this is to make sure that the contens of column B can not be accidentaly viewed by the user of sheet2.

Hope my explanations makes sense

regards,
kbka

[kbka]

I ended up solving this by creating a macro that simply copies the contens of sheet1 and paste that into sheet2 whenever i close the workbook.
works like a charm