VBA Code Has Error 400

[kapeller]

Hi

I am a bit lost with excel at the moment.

The workbook that I have is titled Budget 06102014

In that workbook there are two spreadsheets, one is named Accounts and the other Staff

The accounts sheet has, via the “Name Manger”, including the data area been designated Database1. The staff sheet including the data area been designated Database2.

Each has its own code to open the dataform

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

The issue I have is that when I run, say the staff code I get an Error 400 and then when I run the accounts code the same message.

I am not sure what is going on?

[HaHoBe]

Hi, Lou,

try

Please Login or Register  to view this content.

when the cursor is in the area of the databases.

Ciao,
Holger

[kapeller]

Hi Holger

That did the trick.

Many thanks for your quick response