I built some macros and thought if I moved my Excel file to another
directory, the same code would be found because it is inside the Excel file.
Is there some setting to tell Excel to use the relative path to find the
macros, inside its own file?

Maybe you should state your exact problem.

--
Jim
"Derek Hart" wrote in message
...
I built some macros and thought if I moved my Excel file to another
directory, the same code would be found because it is inside the Excel
file.
Is there some setting to tell Excel to use the relative path to find the
macros, inside its own file?

I built macros that are called by a toolbar button. Works perfectly. Move
the Excel file to another directory. The macros can't be located, because
the file was moved, but the macros are in the darn file. Make sense?

"Jim Rech" wrote in message
...
Maybe you should state your exact problem.

--
Jim
"Derek Hart" wrote in message
...
I built some macros and thought if I moved my Excel file to another
directory, the same code would be found because it is inside the Excel
file.
Is there some setting to tell Excel to use the relative path to find the
macros, inside its own file?

You may find your life becomes much easier by using code to do this work.

You can 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm

Derek Hart wrote:

I built macros that are called by a toolbar button. Works perfectly. Move
the Excel file to another directory. The macros can't be located, because
the file was moved, but the macros are in the darn file. Make sense?

"Jim Rech" wrote in message
...
Maybe you should state your exact problem.

--
Jim
"Derek Hart" wrote in message
...
I built some macros and thought if I moved my Excel file to another
directory, the same code would be found because it is inside the Excel
file.
Is there some setting to tell Excel to use the relative path to find the
macros, inside its own file?








--

Dave Peterson

Let me try again. I have written VBA code in an Excel spreadsheet called
MySheet.xls which is in c:\temp - My code is in a module called Module1, the
default module. I then create a toolbar by hand, and Assign the Macro (not
a recorded macro, but my code in Module1) to toolbar buttons. Works
perfectly. Then move my file from c:\temp to c:\NewDir - click the toolbar
button and get the error "The macro c:\temp\MySheet.xls!TestMacro cannot be
found." I just want the toolbar button to reference THIS file. How do I do
that?


"Dave Peterson" wrote in message
...
You may find your life becomes much easier by using code to do this work.

You can 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de
Bruin's
site:
http://www.rondebruin.nl/ribbon.htm

Derek Hart wrote:

I built macros that are called by a toolbar button. Works perfectly. Move
the Excel file to another directory. The macros can't be located, because
the file was moved, but the macros are in the darn file. Make sense?

"Jim Rech" wrote in message
...
Maybe you should state your exact problem.

--
Jim
"Derek Hart" wrote in message
...
I built some macros and thought if I moved my Excel file to another
directory, the same code would be found because it is inside the Excel
file.
Is there some setting to tell Excel to use the relative path to find
the
macros, inside its own file?








--

Dave Peterson

Right click on each icon and reassign the macro to the button. When/if you move
or share this with others, you could have the same problem.

Or build the toolbar on the fly.

Derek Hart wrote:

Let me try again. I have written VBA code in an Excel spreadsheet called
MySheet.xls which is in c:\temp - My code is in a module called Module1, the
default module. I then create a toolbar by hand, and Assign the Macro (not
a recorded macro, but my code in Module1) to toolbar buttons. Works
perfectly. Then move my file from c:\temp to c:\NewDir - click the toolbar
button and get the error "The macro c:\temp\MySheet.xls!TestMacro cannot be
found." I just want the toolbar button to reference THIS file. How do I do
that?

"Dave Peterson" wrote in message
...
You may find your life becomes much easier by using code to do this work.

You can 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)

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de
Bruin's
site:
http://www.rondebruin.nl/ribbon.htm

Derek Hart wrote:

I built macros that are called by a toolbar button. Works perfectly. Move
the Excel file to another directory. The macros can't be located, because
the file was moved, but the macros are in the darn file. Make sense?

"Jim Rech" wrote in message
...
Maybe you should state your exact problem.

--
Jim
"Derek Hart" wrote in message
...
I built some macros and thought if I moved my Excel file to another
directory, the same code would be found because it is inside the Excel
file.
Is there some setting to tell Excel to use the relative path to find
the
macros, inside its own file?








--

Dave Peterson

--

Dave Peterson