Excel 2007 Command button Properties

[rjc6612]

Hello,

I have managed to create a command button in excel 2007 that performs a macro upon a click. But, after re-opening the workbook, I am unable to right click on the button to recall the properties window. Any ideas?

 

[JoeMo]

Hello,

I have managed to create a command button in excel 2007 that performs a macro upon a click. But, after re-opening the workbook, I am unable to right click on the button to recall the properties window. Any ideas?

Is your command button a forms control or an active-x control? If the latter, go to the Developer tab and select 'Design Mode' first then right-click the button.

 

[rjc6612]

Is your command button a forms control or an active-x control? If the latter, go to the Developer tab and select 'Design Mode' first then right-click the button.

Thank you for replying. I eventually found this was the answer, but only after intensive searching. People tend to forget to mention the simple things. Again, thank you very much for responding. On the internet I found only 1 post explaining this. I only started to use command buttons yesterday.