Making My Macros Stick.

Mr Nick · Apr 9th, 2002, 08:02 AM

How do I ensure that when I do a 'Save As' on my worksheet, all the associated macros will be bound with it?

At the moment, every time I 'Save As' and then press a tool button to activate one of my macros, I get either an error message staing that the path cannot be found or the original worksheet opens and the macro is executed on the original copy.

Al Chara · Apr 9th, 2002, 08:04 AM

Is the toolbar with your macros attached to the original sheet?

Mr Nick · Apr 9th, 2002, 08:08 AM

Yes it is.

Al Chara · Apr 9th, 2002, 08:17 AM

Well then the macro is still looking for the original workbook. Do you want the toolbar button to open up a workbook and then run the macro or is the workbook already open?

Mr Nick · Apr 9th, 2002, 08:27 AM

Quote:

Well then the macro is still looking for the original workbook. Do you want the toolbar button to open up a workbook and then run the macro or is the workbook already open?

The toolbar button is to activate administrator options within this workbook. The toolbar is only loaded when this workbook (or any saved instances) are opened. The toolbar is then disabled when the workbook is closed.

Al Chara · Apr 9th, 2002, 08:34 AM

Sounds like the macro buttons are still pointing to the original workbook. Check to see the path...right click on a toolbar, goto customize, then activate the actual toolbar by clicking on it, then right click the buttons in question, goto assign macro, and check the path, delete the file path and just leave the macro name.

Mr Nick · Apr 9th, 2002, 08:39 AM

Quote:

Sounds like the macro buttons are still pointing to the original workbook. Check to see the path...right click on a toolbar, goto customize, then activate the actual toolbar by clicking on it, then right click the buttons in question, goto assign macro, and check the path, delete the file path and just leave the macro name.

I keep doing this, but every time I do a 'Save As' the paths don't go with the sheet. It's beginning to get my goat having to keep reassigning the macro commands.

Dave Hawley · Apr 9th, 2002, 08:43 AM

Hi Nick

Are you just disabling the Toolbar or Deleting it? If the Toolbar IS attached to the Workbook it may need to be Deleted on Closing. This is a better way alround for attached toolbars.

Mr Nick · Apr 9th, 2002, 08:50 AM

I'm just disabling them at the moment. I'll change it to delete and see how that works.

Cheers.

Mr Nick · Apr 9th, 2002, 08:53 AM

Yahoo!!

Cheers Dave, that's done it.

Apr 9th, 2002, 08:34 AM	#6
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Sounds like the macro buttons are still pointing to the original workbook. Check to see the path...right click on a toolbar, goto customize, then activate the actual toolbar by clicking on it, then right click the buttons in question, goto assign macro, and check the path, delete the file path and just leave the macro name. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 08:02 AM	#1
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	How do I ensure that when I do a 'Save As' on my worksheet, all the associated macros will be bound with it? At the moment, every time I 'Save As' and then press a tool button to activate one of my macros, I get either an error message staing that the path cannot be found or the original worksheet opens and the macro is executed on the original copy.

Apr 9th, 2002, 08:04 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Is the toolbar with your macros attached to the original sheet?

Apr 9th, 2002, 08:08 AM	#3
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	Yes it is.

Apr 9th, 2002, 08:17 AM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Well then the macro is still looking for the original workbook. Do you want the toolbar button to open up a workbook and then run the macro or is the workbook already open?

Apr 9th, 2002, 08:43 AM	#8
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Nick Are you just disabling the Toolbar or Deleting it? If the Toolbar IS attached to the Workbook it may need to be Deleted on Closing. This is a better way alround for attached toolbars.

Apr 9th, 2002, 08:50 AM	#9
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	I'm just disabling them at the moment. I'll change it to delete and see how that works. Cheers.

Apr 9th, 2002, 08:53 AM	#10
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	Yahoo!! Cheers Dave, that's done it.