ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Assigning a macro to a button on a toolbar (https://www.excelbanter.com/excel-programming/401364-assigning-macro-button-toolbar.html)

valerashylin

Assigning a macro to a button on a toolbar
 
Does anybody know the way to assign a macro to a button on a toolbar
(for example, in Excel) so that the macro's name would not be
displayed in the ASSIGN MACRO field in the CUSTOMIZE mode?

(check Adobe Acrobat toolbars, Value converter etc. to make sure that
you can never find out what functions are assigned to the commands on
their toolbars).

Thanks! :)

JP[_3_]

Assigning a macro to a button on a toolbar
 
That dialog box is how you assign the macro to the button. If you were
able to clear it somehow, the button wouldn't work.

You could try disabling toolbar access, check out this page:
http://www.rondebruin.nl/menuid.htm


HTH,
JP


On Nov 19, 11:24 am, valerashylin wrote:
Does anybody know the way to assign a macro to a button on a toolbar
(for example, in Excel) so that the macro's name would not be
displayed in the ASSIGN MACRO field in the CUSTOMIZE mode?

(check Adobe Acrobat toolbars, Value converter etc. to make sure that
you can never find out what functions are assigned to the commands on
their toolbars).

Thanks! :)



valerashylin

Assigning a macro to a button on a toolbar
 
Thanks! :)

On 19 Лис, 18:27, JP wrote:
That dialog box is how youassignthe macro to the button. If you were
able to clear it somehow, the button wouldn't work.

You could try disabling toolbar access, check out this page:http://www.rondebruin.nl/menuid.htm

HTH,
JP

On Nov 19, 11:24 am, valerashylin wrote:



Doesanybodyknowthewaytoassigna macro to a button on a toolbar
(for example, in Excel) so that the macro's name would not be
displayed in theASSIGNMACRO field in the CUSTOMIZE mode?


(check Adobe Acrobat toolbars, Value converter etc. to make sure that
you can never find out what functions are assigned to the commands on
their toolbars).


Thanks! :)- Сховати цитований текст -


- Показати цитований текст -




All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com