|29 Jun 2011||#1|
| || |
embeded controls not working office 2010
I designed a workbook in 2007 excel with the below example of code. All labels and text boxes worked fine.
Selection.Interior.ColorIndex = 43
Workbooks(curwbook).Sheets("Sheet1").Label1.Visible = True
Workbooks(curwbook).Sheets("Sheet1").TextBox1.Visible = True
Application.Wait (Now + TimeValue("0:00:03"))
Workbooks(curwbook).Sheets("Sheet1").Label1.Visible = False
Workbooks(curwbook).Sheets("Sheet1").TextBox1.Visible = False
Now i have a new computer with excel 2010, the above code runs fine with no errors however the labels and textboxes do not show when they are supposed to. If i comment out the Visible = False lines, all Labels and textboxes appear fine !!
Any ideas ?
|My System Specs|
|Similar help and support threads for2: embeded controls not working office 2010|
|windows 7: microsoft office 2010 starter not working properly||Microsoft Office|
|Ms office excel 2010 symbol not working to insert on page||Microsoft Office|
|Windows 7 Flyout Menus Not working for Office 2010 Pinned Taskbar Shor||Microsoft Office|
|Spell and Grammar Check not Working office 2010||Microsoft Office|
|File Validation from Office 2010 to Office 2003 and Office 2007||News|
|Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010||Microsoft Office|
|Office 2010 working with Groupwise 8||Microsoft Office|