When you say "the starting screen is off-center" I assume you mean a
UserForm. It sounds like the development may have been done at a different
screen resolution than the user.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Jim" wrote:
I wrote a 3+Mb program in Excel 2000 for a client that displays in Excel
but is primarily VBA code and dialog boxes. When the client
(administrator) opens the program in Excel 2003, the starting screen is
off-center to the right and slightly low.. The menu bar is okay. Some of
the users will have Excel 2000 and some will have 2003.

This problem occurred for me a few times while I was working on the
program but seemed to cure itself. I never could figure out why it did
this.

The program has a 2100+ record database in it and operates in two modes,
one for an administrator who is pretty computer knowledgeable and the
second is a User mode for about 25 to 30 users.

The program opens in the User mode and I believe this is what is causing
the off-center problem. When the program opens, I capture all the current
user's command bar and Toolsoptions settings which are used to restore
their Excel back to its original configuration. All this occurs in the
ThisWorkbook Open event.

The users access everything from the program menu and the admin logs in
via an option on the program menu.

After this setting capture, I remove the scroll bars, I hide all the menu
items (but create a program menu), workbook tabs, formula bar and
formatting bar and protect the workbook window
with(ActiveWorkbook.Protect Structu=False, Windows:=True). The program
also runs a 4 second flash dialog and an information dialog the user has
to close manually.

I am absolutely stumped and can't replicate the off-center problem now on
my computer although, as I said above, the problem did occur a few times
for me.

Sorry this query is so lengthy and doubt it will receive an answer since
this sounds like something a beginner would ask. If I can't find a
solution to this I'm going to rewrite the whole thing in VB6 with an
Access db but I've already got three weeks invested in this thing and
would like to make it work.

Any help would be greatly appreciated. Greatly appreciated.