View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vdmbqb vdmbqb is offline
external usenet poster
 
Posts: 36
Default clear specific cells in a form

Okay, I am not exactly an Excel genius. I have an Excel spreadsheet form that
is protected from editing in all cells except for the cells that require
changing each time the form is used. For instance, A1 is protected and in the
cell is the word Name and A2 is blank and unprotected so that the name can be
entered. I do have the ability to unprotect the sheet.

I am trying to come up with a way to clear the form of all the unprotected
cells after the form is filled out. I hope that makes sense.

Ron de Bruin has already sent assistance, but I think I am too stupid to
understand. I would really need something specific for me to figure it out.
Any help would be appreciated.

--
bob