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 ?