Windows 7 Forums


Windows 7: embeded controls not working office 2010

29 Jun 2011   #1

Windows 7 Home prem 64 bit, office 2010
 
 
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.

Range("F7").Select
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 SpecsSystem Spec

Reply

 embeded controls not working office 2010 problems?



Thread Tools



Similar help and support threads for: embeded controls not working office 2010
Thread Forum
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


All times are GMT -5. The time now is 08:58 AM.


Seven Forums Android App Seven Forums IOS App Follow us on Facebook

Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32