Thats probably the question I should have asked. So how do you set a
reference to the macros, and where are the macros actually stored??
Thanx for the help so far
Mkingsley
Bob Phillips Wrote:
Oh I see, that only determines which macros are shown in the list, not
where
they can be run from. If you run macros in another workbook, you have
to
qualify with that workbook name, or set a reference to it.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"mkingsley"
wrote
in message
...
Once Excel is open, and I have successfully imported the macro. I
choose (in Excel) ToolsMacroMacros. And a window pops up showing
all macros. this window has the pull down menu: "Macros In", to
choose:
Open in all workbooks
This workbook
Book1
I have chosen "Open in all workbooks" because I want all macros
available no matter what Excel file I open.
thanx
Bob Phillips Wrote:
What/where is ... "Macros In" had checked "Open in all
Workbooks"
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"mkingsley"
wrote
in message
...
I have several VB modules that I have tried importing into an
XP/Office
2003 environment, but can't get them to stay. In my old
98/Office
98
environment, the modules were always there, when I opened a new
file
(PERSONAL.XLS), or any other file.
How do I get my modules to always be available whenever I open
Excel.
Final note, when I imported them, I went to the VB editor to
make
sure
they were there, and made sure that the "Macros In" had checked
"Open
in all Workbooks"
As always any help is appreciated
MK
--
mkingsley
------------------------------------------------------------------------
mkingsley's Profile:
http://www.excelforum.com/member.php...fo&userid=4291
View this thread:
http://www.excelforum.com/showthread...hreadid=554961
--
mkingsley
------------------------------------------------------------------------
mkingsley's Profile:
http://www.excelforum.com/member.php...fo&userid=4291
View this thread:
http://www.excelforum.com/showthread...hreadid=554961
--
mkingsley
------------------------------------------------------------------------
mkingsley's Profile:
http://www.excelforum.com/member.php...fo&userid=4291
View this thread:
http://www.excelforum.com/showthread...hreadid=554961