Hi

I run WinXP with Excel 2K

I have a number if spreadsheets that have macros in them. They all work
fine. I have created a spreadsheet with a "dashboard" in it. That is to say
it is a spreadsheet with a number of autoshapes (buttons) that have
hyperlinks attached to them that when each one is selected they open the
spreadsheet that they are hyperlinked too. This works fine.

Now for my problem.

I have moved all of the spreadsheets (including the one with the dashboard
in it) onto a server drive. When I select one of the dashboard buttons it
opens the desired spreadsheet on the server. This works ok also. However,
when I close the spreadsheet down that has been opened by the hyperlinked
button is when I have the problem. The spreadsheet closes down ok but after a
couple of seconds the dialog box for the spreadsheet I have just closed
appears back on the screen and asks me if I want to run the macros in the
spreadsheet or not. I can then cancel the dialog box and it disappears but it
should not be opening in the first place. Once I cancel it it does not
reappear.

Is there something that I need to put in the worksheet code that ensure it
does not try to open again once the workbook has been closed?

As I said, I dont have any problems when these files are on my hard drive,
only when they are on the server drive.

Thanks

John