Error: "The password you supplied is incorrect.Verify the CAPS LOCK key is off..."

Hi, I am new to Excel Macros and am encountering an issue:

I have a workbook with 5 worksheets and it is implementing an Expense Workflow Process.

After the Initiaor submits the request, 1 of the sheet "Expense Form" is locked for editing. This is working fine.

Please Login or Register  to view this content.

The User has a new requirement. Incase of rejection of this request, the Initiator should be able to edit this worksheet. So I put the following sub code in the Reject button:

Please Login or Register  to view this content.

But I am getting an error:

"The password you supplied is incorrect.Verify the CAPS LOCK key is off..."

Appreciate any inputs as this will be of great help.

Thanks


Moderator Edit:

Welcome to the forum, NigelDeNoronha.

Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

I see no obvious error in your code. It sounds like the error message is indicating the problem it has encountered. There is some non-obvious difference between the current protection password and the string in the cell you are referencing.

your third line should be

Please Login or Register  to view this content.

Thanks a lot JP and all.. It was an issue with the assignment.

Just 1 more assistance please

I am trying to unlock the entire sheet and then lock a section of that sheet. But it gives me the mssg "Unable to set the locked property of the Range Class"

Please Login or Register  to view this content.

I am sorry that I am asking too much but am really new to excel.

Thanks once again

where does the error occur? are you sure the sheet has been unlocked? (your code as posted would not run)

are any of those cells merged? if you check the worksheet when the error occurs is it actually unprotected?

the contents of the cells shouldn't make any difference unless perhaps you have some other code interfering. can you post a sample workbook?

remember when I asked about merged cells? you have merged cells in the range you are unlocking so you have to include all the merged area which means using B15:D20 not C20

If that takes care of your need, please select Thread Tools from the menu above and mark the thread as solved. Thanks.