G
Guest
Guest
Hi. I need help!
I'm using a userfrom to place data onto a worksheet, and want to make sure that the worksheet cannot be changed by a user.
If I have the worksheet protected, I can't place the info gathered in the userform onto the worksheet (gives me an error telling me to unprotect the sheet first).
I have tried using the Activesheet.UnProtect method, but keep on getting an error. The error is:
"Run-Time Error 1004"
"Unprotect method of worksheet class failed"
Can anybody help me? I use a click of an OK button to hold all the coding for placing the info onto the worksheet.
When the button is pressed, I want to unprotect the sheet, enter the data, then reprotect the sheet.
Thanks,
Corey D.
I'm using a userfrom to place data onto a worksheet, and want to make sure that the worksheet cannot be changed by a user.
If I have the worksheet protected, I can't place the info gathered in the userform onto the worksheet (gives me an error telling me to unprotect the sheet first).
I have tried using the Activesheet.UnProtect method, but keep on getting an error. The error is:
"Run-Time Error 1004"
"Unprotect method of worksheet class failed"
Can anybody help me? I use a click of an OK button to hold all the coding for placing the info onto the worksheet.
When the button is pressed, I want to unprotect the sheet, enter the data, then reprotect the sheet.
Thanks,
Corey D.