I have a module that has been working just fine under Excel 2003. I
am now testing it under Excel 2007, in preparation for a rollout of
Office 2007 that will start next week. It runs from a workbook that
has a number of hidden sheets, and contains the following code:

'MsgBox ("1")
ThisWorkbook.Worksheets("Q&A").Visible = True
ThisWorkbook.Worksheets("Q&A").PageSetup.RightFoot er = "Program
Checklist Revision " & revno
'MsgBox ("2")
ThisWorkbook.Worksheets("DocInfo").Visible = True
ThisWorkbook.Worksheets("DocInfo").PageSetup.Right Footer = "Program
Checklist Revision " & revno
'MsgBox ("3")

The msgbox lines are all commented. Under Excel 2007, it crashes on
the 5th line, with a message about being unable to get the worksheet
visible property. When I remove the comment from line 4, I get the
message box and no error. I then put the comment back, and saved, and
again got no error. However, I am nervous about someone getting the
error at some random time, since I can't figure out what caused it,
and what cured it. Does anyone have any ideas?