Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel screen opens off-center
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel screen opens off-center
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 opens as a blank/gray screen - please help :*( | Excel Discussion (Misc queries) | |||
Center Comments on Center of Screen | Excel Discussion (Misc queries) | |||
How can I Center a Dialog Box each time a user opens it? | Excel Programming | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
Excel file opens with a blank screen | Excel Discussion (Misc queries) |