I am very new to this and need a little help.
I have used the following code to clear a Cell using a Command Button.
Private Sub RiskCalculatorReset_Click()
Sheets("01 - Risk Calculator").Range("G11").Value = ""
End Sub
This works, but when I protected the sheet, my unprotected cell does not clear anymore.
Is there any code that will allow me to overcome this?
Hello Ah50,
The only way around this is to unprotect your worksheet whilst you are working on it. Hence, your code amended as follows will do this:-
Then, to protect the sheet again once you are done with it, place the following code in the Worksheet module:-
Please Login or Register to view this content.
Once you leave this sheet, the sheet will be once again protected. To implement this code:-Please Login or Register to view this content.
- Right click on the sheet tab and select "View Code" from the menu that appears.
- Paste the above code in the big white field that then appears.
- Save your workbook.
Test it in a copy of your workbook first.
I hope that this helps.
Cheerio,
vcoolio.
Last edited by vcoolio; 08-21-2018 at 12:06 AM. Reason: Typos.
Thank you very much for your help.
You're welcome Ah50.
Cheerio,
vcoolio.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks