how to I run a VBA app from a custom button

[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...

 

[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.

 

[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.

 

[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"?

 

[Lowell Williams]

OK, duh, figured it out.

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.