|
-
Apr 22nd, 2004, 05:22 PM
#1
Thread Starter
Lively Member
Ancient Symbols taking over my forms!
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.
-----
#VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP
I miss my VIC 20.
Never should have upgraded to my commodore 64. ...
-
Apr 22nd, 2004, 05:29 PM
#2
Thread Starter
Lively Member
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.
-----
#VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP
I miss my VIC 20.
Never should have upgraded to my commodore 64. ...
-
Apr 22nd, 2004, 05:40 PM
#3
Could you have a virus??? Try updating your virus protection and
do a full disk scan for any virus'.
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
-
Apr 22nd, 2004, 06:45 PM
#4
Thread Starter
Lively Member
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.
-----
#VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP
I miss my VIC 20.
Never should have upgraded to my commodore 64. ...
-
Apr 23rd, 2004, 12:03 PM
#5
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
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
-
Apr 23rd, 2004, 09:30 PM
#6
Thread Starter
Lively Member
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.
-----
#VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP
I miss my VIC 20.
Never should have upgraded to my commodore 64. ...
-
Apr 24th, 2004, 04:27 PM
#7
Perhaps a search on M$ would be able to bring up a KB article or
something that could help you out???
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum. 
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it! 
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|