ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet Controls in design mode (https://www.excelbanter.com/excel-programming/321609-worksheet-controls-design-mode.html)

Jared

Worksheet Controls in design mode
 
Whenever a commandbutton control is added to a worksheet, the following
appears in the formula bar:=EMBED("Forms.CommandButton.1","")
If I accidently click on the formula bar, I constantly get an error message
saying that I have an invalid formula even though I haven't changed anything.
This eventually forces me to delete the control and create it again. Is there
any solution to this problem?

Ben

Worksheet Controls in design mode
 
sure DON'T CLICK INTO THE FORMULA BAR.
unfortunately, we all know it happens, try hitting 'Escape' next time

"Jared" wrote:

Whenever a commandbutton control is added to a worksheet, the following
appears in the formula bar:=EMBED("Forms.CommandButton.1","")
If I accidently click on the formula bar, I constantly get an error message
saying that I have an invalid formula even though I haven't changed anything.
This eventually forces me to delete the control and create it again. Is there
any solution to this problem?



All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com