Customised Toolbar with Macro buttons

  • Thread starter Thread starter amit_k74
  • Start date Start date
A

amit_k74

Hi,

I have written around 10-15 macros on one excel sheet and they ar
working fine (Thank God).

However I attached buttons to a customised toolbar. Then I attache
this toolbar to the file.

Perfectly WORKING.

Now I mail it or change the location and it tries to open the file fro
the original location because the macro reference is complete and no
relative.

How do I correct this.

Regards

Ami
 
Amit,

Have you attached the command bar to the workbook? Do this by
going to the View menu, choose Tool Bars, then Customize. In that
dialog, select the Toolbars tab and click Attach. Select your
command bar in the left side list box and click Attach.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Customised Buttons 1
Error message Macro cannot be found 2
Moved file, changed path, macros don't work 3
Ribbon - custom button calls macro with argument 5
Unable to assign macros to a new button in the current worksheet 1
Deleted Custom Toolbar keeps returning. 3
Error due Changed Drive 1
Saving a Macro Button on the Quick Access Toolbar in Excel 1

Back
Top