Making a template with reset button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am helping a co worker with a form that is used every day. It has formulas
in it and I am locking those cells and protecting the sheet to prevent the
form from being altered. Is there an easy way to put a button on the sheet
or toolbar that can be hit and it will clear the unprotected cell
information-thus putting it back to a blank field?
 
Lisa

Sub DeleteUnlockedCells()
Dim rngeCell As Range
Application.ScreenUpdating = False
For Each rngeCell In ActiveSheet.UsedRange.Cells
If rngeCell.Locked = False Then rngeCell.ClearContents
Next
Application.ScreenUpdating = True
End Sub


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protection on Worksheets 5
lock button after click 1
How to creat a template 1
Locked Property off, but cannot select cell 3
Can't move between cells. (Not the scroll lock) 1
Protecting Worksheet - Cannot move between cells. 2
Global Sheet Protection and a Button 8
Attempted edit of protected cell jumps user to another cell 2

Back
Top