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