Runtime error 1004 Activate Method of Worksheet Class Failed - Using Worksheets().Activate

I have a weird problem that only shows up on one machine (go figure)..... When I open the excel file I run a subroutine to do a couple of things: 1) Display a message (text in a cell of a worksheet) 2) and unhide all the worksheets by calling the ShowAllSheets sub routine. I do this so if Macro's are not enabled all you see is the welcome sheet that says "Enable macros"

My code works great on all machines I've tried it on but one. On one machine I get the following error "Runtime error 1004 Activate method of worksheet class failed". The runtime error is associated with this line of code "ActiveWorkbook.Sheets(AdminWorksheet).Activate" Like I said everything works fine except on this one machine. Any ideas would be greatly appreciated?

The code this pertains to is below:

Please Login or Register  to view this content.

If you change that line to this what happens.

Please Login or Register  to view this content.

I will change it and send it to him to check it out on the machine that has the error. I'll have to wait on him though. Do you have an idea why the .Activate would cause an error?

I don't know, and I don't know if what I suggested will work.

Using Application.Goto can sometimes be preferable to Activate.