Hi guys,
I'm looking to create a Macro I can assign to button that will clear the contents of all Unprotected cells in my sheet EXCEPT a specific range of cells (that are also unprotected).
The worksheet is filled out daily, so most of it needs to be cleared and re-entered. However there are a few blocks of cells that change so infrequently that the it isn't efficient for the end user to have to re-enter daily, but they still need access to change them when necessary.
I am using the below code which takes care of the clearing all the unprotected cells. I'm hoping there is an amendment that can be made for it to EXCLUDE the block of cells I'm referring to.
Sub ClearUnlockedCells()
Application.FindFormat.Clear
Application.FindFormat.Locked = False
Cells.Replace "*", "", SearchFormat:=True
Application.FindFormat.Clear
End Sub
Thanks!
Bookmarks