Tom,

I'm not too sure if the below was meant for my post. I checked this link and
couldn't find any reference to my post. I may have missed something ... It
wouldn't be the first time :) !!!!!

Regards,

andy m

Chip Pearson has written code that will support this. See his site:
http://www.cpearson.com/excel/imptext.htm

--
Regards,
Tom Ogilvy

"andym" wrote in message
...
Dear All,

I have an Excel report that shows Regional data.

I have designed a template that gets sent to the different Regions
showing
their data only.

This data is sub-grouped into 11 different categories, the data to be
graphed depending on the Option Button selected.

When I copy the relevant sheets that make up the template into a new
workbook ( I group the required 4 sheets, then Copy to New Book), the
Cell
Link reference follows the Option Button to the newly created workbook.

I wish to make sure that the 11 Option Buttons link to the same cell,
but
to
the new workbook, not the original.

ie.. from:

Cell Link: '[OriginalBook.xls]Sheet1'!$A$1

to:

Cell Link: Sheet1!$A$1

My guess is that some coding will be required, hence my posting in this
newsgroup.

Appreciate your help...


andy m