ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cannot select object to assign/edit macro (https://www.excelbanter.com/excel-programming/274301-cannot-select-object-assign-edit-macro.html)

Iain Paine

Cannot select object to assign/edit macro
 
In an existing workbook i am trying to right-click on a
combo box $ drawing group to select/edit the underlying
macro - i cannot select the object. There is no protection
on the workbook and the security setting is low. Any help
much appreciated....

John Wilson

Cannot select object to assign/edit macro
 
Iain,

It's probably a ComboBox from the Controls Toolbox.
View/Toolbars/Visual Basic.
Toggle "Design" mode (should be the pencil/triangle icon
in the upper left).

John

Iain Paine wrote:

In an existing workbook i am trying to right-click on a
combo box $ drawing group to select/edit the underlying
macro - i cannot select the object. There is no protection
on the workbook and the security setting is low. Any help
much appreciated....



Iain Paine

Cannot select object to assign/edit macro
 
Thanks John - that was it.

-----Original Message-----
Iain,

It's probably a ComboBox from the Controls Toolbox.
View/Toolbars/Visual Basic.
Toggle "Design" mode (should be the pencil/triangle icon
in the upper left).

John

Iain Paine wrote:

In an existing workbook i am trying to right-click on a
combo box $ drawing group to select/edit the underlying
macro - i cannot select the object. There is no

protection
on the workbook and the security setting is low. Any

help
much appreciated....


.



All times are GMT +1. The time now is 01:40 PM.

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