Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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




Thread Tools




Our Sites

Site Links

About Us

Find Us

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

All times are GMT -5. The time now is 04:48 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

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 33