excel loads another workbook to run the macro...


M

micmacuk

Hello there,

In my workbook, I have created a custom toolbar with buttons that
activates macros.

After I have saved the master file under a back-up name, I close it.

Then I want to re-open the master file, at that moment if I click on a
button on the custom toolbar, excel loads the file with the back-up
name in order to access the macro.

Do you know any way around this ?

Cheers
Francois
 
Ad

Advertisements

Ad

Advertisements

M

micmacuk

Thanks Dave,

I understand....
What a task ahead of me as the tool bar I have done has several men
and sub menu + pictures shapes as arrow to navigate dates...etc....

I had already wrote a macro to load the toolbar when opening that fil
and unloade it when closing in the private workbook thingy....

Thought it would have been enough.

Anyway...thanks again for your tip.

Francoi
 

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

Top