Run-time error '1004': Method 'Sheets' of object '_Global' failed

I am using a vba code in Excel for storing a workbook every two minutes. This is running Global, used via network in an Access database. The workbook is showing data from a Counter measures liters on ten different lines.

This VBA code also takes a backup of the spread sheets data at seven o'clock every morning to a sheet in the workbook called History.

When starting the Workbook (Tmb.xls) I am getting the fault "Run-time error '1004': Method 'Sheets' of object '_Global' failed"

In Debug it is stopping in the line: Sheets("Beer Count").Select, its marked in the code.

This means I have to start the macro manually, and then every thing is working OK.

It needs the macro to run automatically on start-up.

Can anybody help? Please?

Please Login or Register  to view this content.

Well two possibilities I can think of:
-There is no sheet called "Beer count" in the active workbook
-The sheet "Beer count" is hidden

Thank you very much.

Suppose I have to live with it. I can't find any fault.

It is important to get it start Automatic. We are depending on it to pay tax to the authorities.

It is dangerous for us, if macros don’t start when we open the workbook.