how do I get to button properties? 2

[RobBroekhuis]

I have a button (an embedded control) placed on an Excel worksheet, and want to change some of its properties. I can't figure out how. Right-clicking on the button doesn't do anything, and in the VBE I can't seem to bring up its property window (I can select the sheet it's on in the project tree window, but in the dropdown of the properties window, I have only the sheet object, not the button object). How do I get to the properties?
Rob

 

[dwilson01]

Try showing the Control Toolbox and click design mode.

View - ToolBars - Control ToolBox

If this doesn't work let us know.

 

[xlbo]

You have to be in design view. Get the VBA toolbar visible and then click on the greeny/blue set square type button (furthest to the right)
You'll then be able to view the properties of the button Rgds
~Geoff~

 

[RobBroekhuis]

Thanks - that worked just fine.
Rob