Excel macro

[32131232424q2]

Hi,

I'd like to know how to assign a macro to a toolbar without the macro opening the original document the macro was written in.

Essentially, I need to open an excel workbook (say book1) to write a macro, but I wan't to use this macro with several workbooks. I've assigned the macro to a toolbar button, but every time i click the button it proceeds to open book1 - how can i stop this so that it works only for that workbook

 

[macropod]

Hi,

Without seeing the code it's hard to say. Perhaps you could post it.

Cheers

[MS MVP - Word]

 

[macropod]

BTW, you really should ask this in the vba forum:

http://www.tek-tips.com/threadminder.cfm?pid=707

Cheers

[MS MVP - Word]

 

[SkipVought]

Forum707.

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[32131232424q2]

Thx for replies,

Here's the code:

Sub updater_()
Application.Calculate
End Sub

I believe this does the same job as hittig F9 on the keyboard, but sometimes on the worksheet f9 doesn't seem to work, so I've written this macro as a work around.

Any ideas, let me know. Thx

 

[macropod]

There's nothing in that macro to open a file - I suspect the problem lies with the button you've attached it to pointing to 'Book1'. In any event, the best place for an application-wide macro is in your Personal.xls file (see Excel's help for details).

I'd also recommend finding out why F9 isn't working, rather than trying to work around it.

Cheers

[MS MVP - Word]