400 Visual Basic error message

Mar 12th, 2002, 10:01 AM

I have a macro button on a workbook(I need it to run on different workbooks). When I click it, it gives me a 400 error message
It only runs on the workbook where the macro is created
What should I do?
Thanks in advance

Andrew · Mar 12th, 2002, 10:06 AM

would you pls quote the marco you are running??

Mar 12th, 2002, 10:16 AM

Sorry how do you quote the macro?

Mar 12th, 2002, 10:28 AM

When you saved your macro you saved it in "This Workbook Only." It is not available to other workbooks.
Re due it and save in "Personal Macro Workbook" if your the only user on that machine it should now be available to all workbooks. BTW I never use this as I find it easier to just copy the macro and paste it into what ever new workbook I want it to run in. That way I can taylor the code to do what ever specialities the new workbook may demand.

Mar 12th, 2002, 10:32 AM

Sorry, could you tell me where can I find the "My Personal Workbook"
Thanks

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

Mar 12th, 2002, 10:01 AM	#1
Guest Posts: n/a	I have a macro button on a workbook(I need it to run on different workbooks). When I click it, it gives me a 400 error message It only runs on the workbook where the macro is created What should I do? Thanks in advance

Mar 12th, 2002, 10:06 AM	#2
Andrew New Member Join Date: Mar 2002 Posts: 30	would you pls quote the marco you are running??

Mar 12th, 2002, 10:16 AM	#3
Guest Posts: n/a	Sorry how do you quote the macro?

Mar 12th, 2002, 10:28 AM	#4
Guest Posts: n/a	When you saved your macro you saved it in "This Workbook Only." It is not available to other workbooks. Re due it and save in "Personal Macro Workbook" if your the only user on that machine it should now be available to all workbooks. BTW I never use this as I find it easier to just copy the macro and paste it into what ever new workbook I want it to run in. That way I can taylor the code to do what ever specialities the new workbook may demand.

Mar 12th, 2002, 10:32 AM	#5
Guest Posts: n/a	Sorry, could you tell me where can I find the "My Personal Workbook" Thanks