hi,
has anybody encountered a bug where a .xlsm file would not accept the password to open it
the only solution is to restart my pc
after restart then it would accept the password
happened to me recently twice already for the same .xlsm file
inside the file is just a simple macro
No, cannot say I have seen that problem.
This may be a stupid question, but are you sure you are using the correct P/W?
Next time, when you can open to, try to remove the PW, save, close and re-open - see if the problem goes away.
Then save with a REALLY simple PW (aaa), close, reopen
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Could you have accidentally turned Caps Lock on/off? Since the password is Case sensitive, you will get a wrong PW error because you are entering CAPS.
I hope this helps, please let me know!
Regards,
David
If this has been helpful
- Please click on the *Add Reputation button at the bottom left.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
hi,
im really sure im entering the correct password
i even type slowly character by character making sure i type the correct one
im also sure the caps lock is toggled correctly
ive also noticed the bug happens when ive accessed (open/close) the file several times
the latest incident when i could not open it i closed the file closed excel
restarted pc then when i opened excel (i have not click to open the file yet)
it said something about an error opening the file (forgot the exact statement)
and that if i would like excel to repair it
i clicked ok then a message saying it cannot repair the file coz its corrupted
i closed the message, double clicked the file to open it prompted for the password
no error message, typed the password, then the file opened there was no error
this is the macro insisde the file
Please Login or Register to view this content.
found the culprit my keyboard has been remapped
when i press shift+2 it should type @ it doesnt, it actually types " (double quote)
and when i press shift+" it should type " (double quote) it doesnt, it actually types @
it only resets after restarting my pc but eventually it gets remapped again i guess after several hours
maybe have a virus or something i dont know
Last edited by k1dr0ck; 01-18-2017 at 05:38 AM.
Thanks for letting us know. Never would have thought of that. Re-mapping a keyboard is outside my experience!
David
I would not have thought of that either.
Is there perhaps some VBA running in the background that could do that?
Or maybe someone else playing a trick on you ?
That is also possible
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks