how they do that?

[Patrick Molloy]

3 possible ways.

1) Using the Add_in manager under the Tools menu
2) saving a file in the default xlstart folder
3) saving the file under the alternative xlstart folder

each of these can easily be checked...

theer is another way, but its more complex and is for
using component objects - and I suspect a bit techy for
this answer.

As a default, there's a file called Personal.xls in the
xlstart foldeer where you can save your code. This file
is hidden when opened in Excel...look under the Windows
menu. If there is a hidden file the unhide menu item will
be enabled.


HTH

Patrick Molloy
Microsoft Excel MVP

 

[!]

1) There is no Add_in
2) & 3) no file in xlstart folder ( under my profile or in program files\MS
office dir)

there is no "hided" file too......

Thus, I guess it is written in component object, is there any way to check
if it exist?
Thank you

!

 

[Patrick Molloy]

open the IDE (Alt & F11)
Look in the project viewer...there's one project for the
book you're in
eg

VBAProject(Book1)

if there are certain types of ad-in they may appear as
well. If not, look in the onject browser (F2) and under
Tools/references

 

[!]

thank you
Here comes a new question.

I found that if I assign a marco to the self-created toolbar, it will
somehow record the location of the file automatically.
If I change the location of the workbook, the "pointer" will still point to
the old one and thus fail to execute the macro.

How can I change the setting of the macro?
..
Thanks

 

[Robin Hammond]

1. make the macro workbook an add-in, so that you are just passing the macro
name, not the book, or
2. create a custom toolbar and attach it to the workbook, so that when you
move the book, the toolbar moves with it, or
3. create the toolbar on the fly when you open the workbook in an auto_open
routine, or best,
4. a combination of 1 and 3.

Robin Hammond
www.enhanceddatasystems.com