Help with Excel VBA (Automation Error)

[comfortablethumb]

Ok, i have been working on a workbook for the past couple of days, and i have ran into a little trouble, this workbook is quite large, with about 7/8 sheets and i use control buttons so the user can navigate through them.

One of these sheets is named 'Input' and i basically use the code Sheets("Input").Select to switch to this particular sheets, but alas now that im right at the end of making this workbook everything time i try to execute this command i get a debug error saying:

Run-time error '2147319765 (8002802b)':

Automation Error
Element not found


For the life of me i cant work out why it has just began to do this, as it wasnt doing this when i first started making the workbook...

Anyhelp on this matter would be much appreciated

 

[SkipVought]

Hi,

Did you change the name of your sheet?

I prefer NOT to use the Sheet Name. Rather, I give a value to the Sheet CodeName in the VB Editor Project Explorer. For instance, if the Sheet is named Input, I make the CodeName wsInput and use the code like this...

wsInput.Activate

In this way, the user (or designer) can't mess up your code by renaming a sheet.


Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}