I have created a selection that goes there on open and has a
drop down menu, then is removed on close, but

Is it possible to create a button named "Update" that can
run a sub when you select it?

Right now if I press [ALT] F it will drop down my File menu

It would be nice If I could press [ALT] U and run the macro
associated with the newly create button

Does anyone have any ideas or suggestions on this?

Thanks,

Jeff W.

I take it that you are using msoControlPopup to create the menu up
top. Simply change that to msoControlButton and make any other
necessary changes to variables and such and just add an OnAction to
it. Of course, you would need to remove all the other code underneath
it that creates the menu items as you only want a single button.

Jeff W. wrote:
> I have created a selection that goes there on open and has a
> drop down menu, then is removed on close, but
>
> Is it possible to create a button named "Update" that can
> run a sub when you select it?
>
> Right now if I press [ALT] F it will drop down my File menu
>
> It would be nice If I could press [ALT] U and run the macro
> associated with the newly create button
>
> Does anyone have any ideas or suggestions on this?
>
> Thanks,
>
> Jeff W.

Just assign a shortcut key to the macro...
On the "Macro" menu select "options" and then assign a CRTL+key to use.

To use the command bar option and assign the ALT key to be part of the
sub-menu item, like alt+f for FILE, then alt+s for save... take a look at the
controls("???").shortcuttext property
This will let you assign the letter when combined with ALT that will run the
..OnAction assigned macro. It will show the "_" for that letter in the menu
text too.

--
Regards,
John


"Jeff W." wrote:

> I have created a selection that goes there on open and has a
> drop down menu, then is removed on close, but
>
> Is it possible to create a button named "Update" that can
> run a sub when you select it?
>
> Right now if I press [ALT] F it will drop down my File menu
>
> It would be nice If I could press [ALT] U and run the macro
> associated with the newly create button
>
> Does anyone have any ideas or suggestions on this?
>
> Thanks,
>
> Jeff W.
>
>
>

I give that a try...

Thanks,

<Jeff>

"John Keith" <(E-Mail Removed)> wrote in message
news:9FA169B3-A786-4B87-A285-(E-Mail Removed)...
> Just assign a shortcut key to the macro...
> On the "Macro" menu select "options" and then assign a CRTL+key to use.
>
> To use the command bar option and assign the ALT key to be part of the
> sub-menu item, like alt+f for FILE, then alt+s for save... take a look at
> the
> controls("???").shortcuttext property
> This will let you assign the letter when combined with ALT that will run
> the
> .OnAction assigned macro. It will show the "_" for that letter in the
> menu
> text too.
>
> --
> Regards,
> John
>
>
> "Jeff W." wrote:
>
>> I have created a selection that goes there on open and has a
>> drop down menu, then is removed on close, but
>>
>> Is it possible to create a button named "Update" that can
>> run a sub when you select it?
>>
>> Right now if I press [ALT] F it will drop down my File menu
>>
>> It would be nice If I could press [ALT] U and run the macro
>> associated with the newly create button
>>
>> Does anyone have any ideas or suggestions on this?
>>
>> Thanks,
>>
>> Jeff W.
>>
>>
>>