![]() |
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.... |
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.... |
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