View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chuckm chuckm is offline
external usenet poster
 
Posts: 15
Default 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