how to I run a VBA app from a custom button

L

Lowell Williams

I know this is stupid but: What command do I use to start my VBA app
(outside of running it with the VBA environment)? I have looked and looked
through my docs and I can't find anything...
 
T

Ty Anderson

The simplest method is to manually create an icon and assign the VBA macro
to it.


You can customize the command bars by selecting TOOLS | CUSTOMIZE.

With the customize dialog window open, select the Commands tab.

In the left side of the form, select Macros from the Categories section.

If you have macros available, they will be listed in right hand side labled
Commands.

Simply drag and drop the desired macro to the command bar of your choice.

That should do it.
 
L

Lowell Williams

This is a VBA application, not a Macro. The VBA App name doesn't seem to
appear the in the list of availble macros and I cannot see a way to run a
VBA app from a MACRO.
 
L

Lowell Williams

While we're at it, is there a way to have a VBA at run as soon as the
document opens? like an "Autoexec"?
 
L

Lowell Williams

OK, duh, figured it out.

Ty Anderson said:
The simplest method is to manually create an icon and assign the VBA macro
to it.


You can customize the command bars by selecting TOOLS | CUSTOMIZE.

With the customize dialog window open, select the Commands tab.

In the left side of the form, select Macros from the Categories section.

If you have macros available, they will be listed in right hand side labled
Commands.

Simply drag and drop the desired macro to the command bar of your choice.

That should do it.
 
Top