Had a macro and saved the blank workbook as an excel add-in. Added to
c:\documents and settings\USER\application
data\microsoft\addins\nameoffile.xla on the workstation under that userid.

Opened excel and turned on Tools | Addins | selected the addin.

The macros do not show in if I look at Tool | Macros. We have had this
problem with our addins since moving to Office 2003. These worked fine on
the workstation with Office 2000. Any ideas?

Macros with arguments, macros declared as Private, macros in a module
with an Option Private Module statement will not appear in Tools | Macro | Macros.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
Had a macro and saved the blank workbook as an excel add-in. Added to
c:\documents and settings\USER\application
data\microsoft\addins\nameoffile.xla on the workstation under that userid.
Opened excel and turned on Tools | Addins | selected the addin.
The macros do not show in if I look at Tool | Macros. We have had this
problem with our addins since moving to Office 2003. These worked fine on
the workstation with Office 2000. Any ideas?

This is a public module with NO arguments. Again we place in the directory
below and if you go into macros, the macro does not show. Again if I place
this back on a machine with Office 2000 in the same directory, the macro
shows up just fine. Something since we have moved to Office 2003. Group
policies or such perhaps? What plays in the macros showing? If I go into
Alt F11 (VBA), click on Tools | Macros in that VBAProject, I can see the
ConnecttoDB macro just fine. Just not from within book1 or whatever?

"Jim Cone" wrote:


Macros with arguments, macros declared as Private, macros in a module
with an Option Private Module statement will not appear in Tools | Macro | Macros.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
Had a macro and saved the blank workbook as an excel add-in. Added to
c:\documents and settings\USER\application
data\microsoft\addins\nameoffile.xla on the workstation under that userid.
Opened excel and turned on Tools | Addins | selected the addin.
The macros do not show in if I look at Tool | Macros. We have had this
problem with our addins since moving to Office 2003. These worked fine on
the workstation with Office 2000. Any ideas?

The only thing I can add is...
that the default behavior for xl97 thru xl2003 is to NOT show the name
of procedures in Tools | Macro | Macros, if the workbook is an add-in.
A workbook can have an .xla extension and not be an add-in.
(the "IsAddin" property must be set to true)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
This is a public module with NO arguments. Again we place in the directory
below and if you go into macros, the macro does not show. Again if I place
this back on a machine with Office 2000 in the same directory, the macro
shows up just fine. Something since we have moved to Office 2003. Group
policies or such perhaps? What plays in the macros showing? If I go into
Alt F11 (VBA), click on Tools | Macros in that VBAProject, I can see the
ConnecttoDB macro just fine. Just not from within book1 or whatever?


"Jim Cone" wrote:
Macros with arguments, macros declared as Private, macros in a module
with an Option Private Module statement will not appear in Tools | Macro | Macros.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
Had a macro and saved the blank workbook as an excel add-in. Added to
c:\documents and settings\USER\application
data\microsoft\addins\nameoffile.xla on the workstation under that userid.
Opened excel and turned on Tools | Addins | selected the addin.
The macros do not show in if I look at Tool | Macros. We have had this
problem with our addins since moving to Office 2003. These worked fine on
the workstation with Office 2000. Any ideas?

Where do I set this. If I go into the code (actually open just the XLA file,
and go into VBA, I cannot locate where you set the property to an add-in).
HELP??

"Jim Cone" wrote:


The only thing I can add is...
that the default behavior for xl97 thru xl2003 is to NOT show the name
of procedures in Tools | Macro | Macros, if the workbook is an add-in.
A workbook can have an .xla extension and not be an add-in.
(the "IsAddin" property must be set to true)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
This is a public module with NO arguments. Again we place in the directory
below and if you go into macros, the macro does not show. Again if I place
this back on a machine with Office 2000 in the same directory, the macro
shows up just fine. Something since we have moved to Office 2003. Group
policies or such perhaps? What plays in the macros showing? If I go into
Alt F11 (VBA), click on Tools | Macros in that VBAProject, I can see the
ConnecttoDB macro just fine. Just not from within book1 or whatever?


"Jim Cone" wrote:
Macros with arguments, macros declared as Private, macros in a module
with an Option Private Module statement will not appear in Tools | Macro | Macros.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
Had a macro and saved the blank workbook as an excel add-in. Added to
c:\documents and settings\USER\application
data\microsoft\addins\nameoffile.xla on the workstation under that userid.
Opened excel and turned on Tools | Addins | selected the addin.
The macros do not show in if I look at Tool | Macros. We have had this
problem with our addins since moving to Office 2003. These worked fine on
the workstation with Office 2000. Any ideas?

In the VBE, you can press F4 or go to the menu: View | Properties window.
If you have the correct workbook (project) selected, then selecting "ThisWorkbook"
displays the properties for the workbook. They are in alphabetical order.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
Where do I set this. If I go into the code (actually open just the XLA file,
and go into VBA, I cannot locate where you set the property to an add-in).
HELP??

"Jim Cone" wrote:


The only thing I can add is...
that the default behavior for xl97 thru xl2003 is to NOT show the name
of procedures in Tools | Macro | Macros, if the workbook is an add-in.
A workbook can have an .xla extension and not be an add-in.
(the "IsAddin" property must be set to true)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
This is a public module with NO arguments. Again we place in the directory
below and if you go into macros, the macro does not show. Again if I place
this back on a machine with Office 2000 in the same directory, the macro
shows up just fine. Something since we have moved to Office 2003. Group
policies or such perhaps? What plays in the macros showing? If I go into
Alt F11 (VBA), click on Tools | Macros in that VBAProject, I can see the
ConnecttoDB macro just fine. Just not from within book1 or whatever?


"Jim Cone" wrote:
Macros with arguments, macros declared as Private, macros in a module
with an Option Private Module statement will not appear in Tools | Macro | Macros.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"SkyEyes"
wrote in message
Had a macro and saved the blank workbook as an excel add-in. Added to
c:\documents and settings\USER\application
data\microsoft\addins\nameoffile.xla on the workstation under that userid.
Opened excel and turned on Tools | Addins | selected the addin.
The macros do not show in if I look at Tool | Macros. We have had this
problem with our addins since moving to Office 2003. These worked fine on
the workstation with Office 2000. Any ideas?