Runtime error 1004: Select method of worksheet class failed
I have a workbook that works fine for me. But gives the above error when someone else tries it.
In Workbook_Open I have:
Application.ScreenUpdating = False
Sheets("Config").Select ====== it bombs here. Config definitely exists.
' read in key
key = Trim(Cells(2, 12))
Sheets("Readme").Select
Application.ScreenUpdating = True
I have run this on many versions of Excel with no problem (2010, 2007, 97....) on Win8, Win7 and earlier versions. I cannot reproduce the problem that the other person gets every time. They are running 2010 on win8. They have no other worksheets open.
Can anyone offer some guidance or advice?
Thanks
chuck
|