Toolbar Error - can't find macros
 

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

Toolbar Error - can't find macros
 

Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)



Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

Toolbar Error - can't find macros
 

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

On Oct 30, 8:20 pm, Dave Peterson wrote:
Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)



Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

Toolbar Error - can't find macros
 

I should rephrase that - I meant toolbars.

On Oct 30, 8:26 pm, Tim879 wrote:
Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

On Oct 30, 8:20 pm, Dave Peterson wrote:

Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

Toolbar Error - can't find macros
 

The second link is what I use when I want a toolbar.

Tim879 wrote:

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

On Oct 30, 8:20 pm, Dave Peterson wrote:
Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)



Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

--

Dave Peterson

Toolbar Error - can't find macros
 

I see how the second link works, but unless I am misunderstanding your
point, that would mean I need to recreate my toolbars.

Is there any way to do this where I don't have to recreate them?

On Oct 30, 9:01 pm, Dave Peterson wrote:
The second link is what I use when I want a toolbar.



Tim879 wrote:

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

On Oct 30, 8:20 pm, Dave Peterson wrote:
Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

--

Dave Peterson

Toolbar Error - can't find macros
 

You could loop through the toolbar icons and reassign the macro, but that is a
temporary measure. If you move to another pc, then you're going to have the
same problem.

But if you want, you could look at this code:

http://groups.google.co.uk/group/mic...696703 4ce7cb

or

http://snipurl.com/hwet

I still think building the toolbars on the fly is easier in the long run.

Tim879 wrote:

I see how the second link works, but unless I am misunderstanding your
point, that would mean I need to recreate my toolbars.

Is there any way to do this where I don't have to recreate them?

On Oct 30, 9:01 pm, Dave Peterson wrote:
The second link is what I use when I want a toolbar.



Tim879 wrote:

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

On Oct 30, 8:20 pm, Dave Peterson wrote:
Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

Toolbar Error - can't find macros
 

Dave,

Thanks for the replies and your help. I really appreciate it. I
definitely plan to use your technique going forward.

Have a great day!
Tim

On Oct 31, 2:56 pm, Dave Peterson wrote:
You could loop through the toolbar icons and reassign the macro, but that is a
temporary measure. If you move to another pc, then you're going to have the
same problem.

But if you want, you could look at this code:

http://groups.google.co.uk/group/mic....misc/browse_f...

or

http://snipurl.com/hwet

I still think building the toolbars on the fly is easier in the long run.



Tim879 wrote:

I see how the second link works, but unless I am misunderstanding your
point, that would mean I need to recreate my toolbars.

Is there any way to do this where I don't have to recreate them?

On Oct 30, 9:01 pm, Dave Peterson wrote:
The second link is what I use when I want a toolbar.

Tim879 wrote:

Thanks for the great tip. I was considering this option but didn't
know how to do it and wasn't sure if I could "export" my current
settings somehow so that I don't have to recreate the menus from
scratch.

Any suggestions

On Oct 30, 8:20 pm, Dave Peterson wrote:
Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

Tim879 wrote:

I am trying to transfer my macros / menus from my work PC to my home
PC.

I have located my personal.xls and also my Excel11.xlb file and copied
them to my home PC.

I created a lot of toolbars that refer to the many macros I've
created, problem is that when I click on these menu buttons on my home
PC, they try to run the macro from the folder where I store my
personal.xls at work.

i.e. my personal.xls is currently stored in:
C:\Documents and Settings\***Carly***\Application Data\Microsoft\Excel
\XLSTART

When I click on when of the menu buttons I've created, it looks for
the macro in
C:\Documents and Settings\***bradshti***\Application Data\Microsoft
\Excel\XLSTART

I added the *'s to emphasize the difference.

I know how to assign a macro to a menu button but this isn't really
feasible to do for the 100+ buttons I have. Is there anyway to change
where these toolbars look for my macros? I can't find any place to
edit this path.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson