12

I am adding a button in an existing Excel file. I noticed that the existing buttons has the EMBED formula specified to it. What does the function mean?

=EMBED("Forms.CommandButton.1","")
ZygD
  • 22,092
  • 39
  • 79
  • 102
Nap
  • 8,096
  • 13
  • 74
  • 117

1 Answers1

10

Honestly there really is not much documentation available on this "function". It is one of those things which are exposed unnecessarily when it really shouldn't have been. We are not supposed to enter this manually.

When you select a CommandButton and place it in Excel, you will see 

=EMBED("Forms.CommandButton.1","")

in the Formula Bar. This text is necessary and should not be deleted. It is Excel's way of telling itself that an object has been inserted.

Cody Gray - on strike
  • 239,200
  • 50
  • 490
  • 574
Siddharth Rout
  • 147,039
  • 17
  • 206
  • 250
  • Is this only for pre-Excel 2007 feature. I tried to add a command button using Excel 2007 and it does not have the embed function, I cannot wire auto functions to it within the sheet. – Nap Feb 21 '12 at 07:07
  • 2
    No. It is also available in Excel 2007 and 2010 as well. You will only see that function if you are using an ActiveX Control and not a form control. – Siddharth Rout Feb 21 '12 at 07:16
  • 4
    While this answer is correct, more information can be found here: http://stackoverflow.com/a/31353117/3566998 – Excel Hero Jul 13 '15 at 15:31