PDA

Click to See Complete Forum and Search --> : Ancient Symbols taking over my forms!

TheFIDDLER
Apr 22nd, 2004, 05:22 PM
Anybody else ever get this with Excel 97.

I have a user form with text, some boxes, and etcs. Just your usual user form. And everything is going smoothly.

Then for no apparent reason, the labels change to Wingdings so that your form looks like it was written for Ancient Egypt. Doesn't affect anything other than labels. Even reads Wingdings in my form properties. (Which I did not change)

And then for no apparent reason, I close the workbook, reopen it and my fonts are back to normal.

OR

Why does this happen?
I hide all menus so that my sheet view goes all the way to the top of the screen, except for the Excel Application bar. Occasionally, after running code, the screen will cease to redraw the very first line on the screen, showing instead this grey bar of nothingness. And I have yet discovered a way to have Excel redraw this missing portion of my screen.
TheFIDDLER
Apr 22nd, 2004, 05:29 PM
More on my wingdings nightmare -

One form - a mutitab strip with 4 pages

It changed my frame labels (and only my frame labels) to wingdings from Arial but only on 3 of 4 of the multipage tab strip.

I would love to know what caused this.
RobDog888
Apr 22nd, 2004, 05:40 PM
Could you have a virus??? Try updating your virus protection and
do a full disk scan for any virus'.
TheFIDDLER
Apr 22nd, 2004, 06:45 PM
I have Norton 2003 installed on my computer. A registered version at that.
Updates from web automatically, last upate yesterday.
Runs a check each morning at nine. None that it can pick up.
RobDog888
Apr 23rd, 2004, 12:03 PM
I don't think its anything to do with your code. It could also be
memory issue. Test by checking your Excel code on another
system. If it runs ok then its on your system. What is may be ???

HTH
TheFIDDLER
Apr 23rd, 2004, 09:30 PM
I'm quite sure it has nothing to do with my code.

I also know that these are minor Excel bugs within 97. What I am trying to sort out is the pattern behind the random occurences of the two events.

But lesson #1 - when coding forms, use labels and stay away from using the frame caption. This seems to only affect frame captions.

I think the memory allocation within Excel could likely be the culprit. I have often commented that this effect seems to spread throughout my files as I open more documents. But if I close everything, restart than my settings are back to normal.
RobDog888
Apr 24th, 2004, 04:27 PM
Perhaps a search on M$ would be able to bring up a KB article or
something that could help you out???