Messagebox to choose which links to follow

[drknot]

Hi All

Using Excel 2003 / XP - soon to be upgraded to Excel 13 / Windows 7

Is it possible to get a message box to appear upon opening the workbook and then depending upon the response.

If the response is yes - select links from workbook "A"
If the response is no - select links from workbook "B"
If the response is cancel - don't update any links

Ideally the response would be captured in a cell

The links would then be updated based on the value of the cell.

The cells with the links will have a simple if statement directing it to the right workbook, this part I can do quite easily, its just the message box and output I'm struggling with.


Thanks for any help

cheers
andy

[Kaper]

Adopt to your needs:

Please Login or Register  to view this content.

[drknot]

Thanks for this,

I didn't realise it would be so simple.

cheers

Andy