View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default 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....