Hi,

I am having trouble with the assigniong of macros to buttons and I will try to explain it now.

I have a spreadsheet 1 that creates a new spreadsheet by copying 2 sheets from the original spreadsheet ansd then saving to an assigned place. On these sheets I have buttons that are assigned to codein Check.xls that is stored in XLSTART so is always available.

All works well until they pass (via disk) the created spreadsheet to a new PC. The macors are then looking for the old path even thougfh ?I have a Check.xls open on the new PC too.

Is there a way to run whenever a new spreasheet is opened so that I can re assign the maco buttons if needed or would it make sense to create a tioolbar with the options I want ?

Brian