Hi,

Am Fri, 8 Nov 2013 11:07:58 -0800 (PST) schrieb chuckm:

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

you don't have to use Select. Try:

Application.ScreenUpdating = False

With Sheets("Config")
' read in key
key = Trim(.Cells(2, 12))
End With

Sheets("Readme").Select
Application.ScreenUpdating = True


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2