J
Jim
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 Tools>options 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
Structure:=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.
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 Tools>options 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
Structure:=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.