My macro in Excel does not recoginze the password I entered. Why?
I recorded a macro in excel to unlock cells and then password protect it. I ran my macro it seems to work great. It unlocks cells so that text can be entered and then password protects it. But once I reopen the file and then go to tools to unprotect it… I am not being asked for the password I entered when I recorded the macro. It just unlocks it as if I did not enter any password. Does anyone know why it does not ask me for the password I entered when I recorded the Macro?
Editor’s comment
If you need to recover a lost or forgotten password for a Microsoft Office document, database or spreadsheet…Click Here to download your password recovery software
Tagged with: cells • macro in excel
Filed under: Microsoft Excel
Like this post? Subscribe to my RSS feed and get loads more!
When you unprotect the sheet, you need the password to unlock all cells
But When you protect it again, you have to re-enter the password
The Uprotect command line is
Worksheets( "Sheet1").Unprotect "password"
The ptorect command line
Worksheets( "Sheet1").Protect "password"
Just use these commands in VBA and you will get it
Enjoy my profile, I am the VBAXLMan