Display issues with upgrade 2000 to XP

[cclambie]

Hi all,

I am having some display issues with an upgrade from Excel 2000 to
Excel 2003 (XP)

One piece of code that could be an issue:
If DisplayVideoResolution = "1024 x 768" Then
ActiveWindow.Zoom = 100
ElseIf DisplayVideoResolution = "800 x 600" Then
ActiveWindow.Zoom = 78
ElseIf DisplayVideoResolution = "640 x 480" Then
ActiveWindow.Zoom = 64
End If

Other issues that could be related:
- Combo box on page is getting bigger everytime you click it?
- Command Buttons acting similar
- Warning Message "Not enough System resources to display all the
data"


I have tried going into edit the size of the buttons in XP and have
found that the issues come on further at this point:
- unable to select objects in design mode
- size issues
- fonts
- combo box
After I resized (could select first time) the size change was to get
smaller instead of larger??

I have little confidence it fixing this as the forum entries, including
http://www.excelforum.com/showthread.php?t=484207&highlight=upgrading
are not boosting my confidence at all.

If anyone can help, I would greatly appreciate it.

 

[cclambie]

Temporary Solution found:

I commented out the code for setting the zoom feature and the issue has
appeared to go away, except the error "Not enough memory to display full
content" is still showing.

The reason I could not select the combo box and resize (after the first
time) was due to the Protection feature coming on automatically after
the page is updated (coded in to SS)