ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Assign macro to button in EXCEL 2003 (https://www.excelbanter.com/excel-programming/287198-assign-macro-button-excel-2003-a.html)

Steffen Kuenstner

Assign macro to button in EXCEL 2003
 
Hi,

I was just trying to assign a macro to a button in EXCEL 2003. The command
line is there "Assign macro..." but when I click it nothing happens. It
worked in all previous EXCEL versions... :-((

I changed the security settings but it won't work.

Thanks for your help,

Steffen



patrick molloy

Assign macro to button in EXCEL 2003
 
You're using a button from the Forms bar
When you right-click see that the 'Assign Maco...' menu
item is enabled ie not greyed out. This will be the case
if you right-click on the button's text. make sure that
you're pointing at the button's border when you right-
click and you'll see this item enabled.

HTH
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi,

I was just trying to assign a macro to a button in EXCEL

2003. The command
line is there "Assign macro..." but when I click it

nothing happens. It
worked in all previous EXCEL versions... :-((

I changed the security settings but it won't work.

Thanks for your help,

Steffen


.



All times are GMT +1. The time now is 12:28 PM.

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