PDA

View Full Version : Excel with Win-98 & XP



Prasad_Joshi
11-18-2006, 03:07 AM
I have given a password to Excel VBA Project with Alt key combinations like Alt123,through Win-98 & Excel-2000. Now I am having MS XP with Excel-2000/03. The password I am typing is incorrect. What is wrong ? XP not supporting the characters with Alt combinatons ?
:(
Prasad

mdmackillop
11-18-2006, 03:51 AM
I've just tried protecting and unprotecting a VBA project in 2003 using Alt123 repeated 3 times as the password. No problems found.

Prasad_Joshi
11-20-2006, 02:48 AM
With new developed files in Excel-2000 or 03 does not create a problem. My files were from Windows-98 with Excel-2000. Now I am using XP & facing a problem during entering a password with alt combinations.

Prasad

rbrhodes
11-20-2006, 03:38 PM
Hi Prasad,

Have you checked to see if it is a problem with character sets rather than a problem in win98/XP, Excel versions? <ALT + #> can echo different chars on any two machines if the char sets are different.

So if your code is expecting ??? and gets ??#, using the same <ALT+#> key combo, error.

I would try "echoing" the ALT key input with a msgbox, to see if what you're inputting is actually what you want/think it is!

Just a thought.

dr



Sub checkPword()
p = InputBox("Password?") 'Input <ALT+ #>
MsgBox (p) ' Output _this_ computers' value for <ALT+#>
End Sub