One way link

[Scamp]

I need to link an Excel sheet to a word document.

It needs to be a link so that the word document shows the current data
from the Excel sheet.

I do NOT want the user to be able to go back and look at the Excel
sheet via the "edit" or "open" link commands. They are only allowed
to see a specific range of this sheet not the entire thing.

Is there an easy way to block that?

Thanks.

 

[Puppet_Sock]

I need to link an Excel sheet to a word document.

It needs to be a link so that the word document shows the current data
from the Excel sheet.

I do NOT want the user to be able to go back and look at the Excel
sheet via the "edit" or "open" link commands. They are only allowed
to see a specific range of this sheet not the entire thing.

Is there an easy way to block that?

Hmm... Does putting the workbook with the data in a readonly location
satisfy the requirements? Users might still be able to get a copy of
the workbook and see the rest of the workbook.

Hmm... You could make a "report" Excel workbook and link to that.
Put that in a read only location (read only for the users) and update
it as required. If it had only the data the users were allowed and
was on read-only disk space, that seems to satisfy that end.

Then to update it, you could have a macro on your real workbook.
Press a button and it updates the report workbook.
Socks