0

Excel 2010 :

1) enter image description here Excel Macro contains "Properties,View Code and CommandButton Object menus on right click.

2) enter image description here Same Excel Macro does not show "Properties,View Code and CommandButton Object menus on right click. What is the reason,not showing menus.How to get this properties.I would have tried to changing excel properties.

Mark Fitzgerald
  • 3,048
  • 3
  • 24
  • 29
0143.NetUser
  • 29
  • 1
  • 13

1 Answers1

0

There are two different kinds of controls possible in an Excel worksheet. Both can be inserted via developer tab:

enter image description here

Your first one is an ActiveX control.

Your second one is an Form control.

See also: What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Axel Richter
  • 56,077
  • 6
  • 60
  • 87