I tried this, but when I press Ctrl-F3 nothing happens. Is that because I am
using Office XP

--
bob


"Ron de Bruin" wrote:

Hi vdmbqb

I love your name<g

Hold your Ctrl key when you select all cells that you want to clear
Then use Ctrl-F3 to give this range a name

You can use this code line then to clear the cells
Range("MyRange").ClearContents


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vdmbqb" wrote in message ...
I have a form written in excel 2003. Every cell on the form is locked except
the cells that require new info each time. For instance, cell A1 reads NAME
and cell A2 is blank and allows you to enter a persons name. At the top of
the form is a button that reads "CLEAR FORM". When you click on the button
all cells that are not locked for editing clear and you can reuse the form
for the next person. I need to recreate the CLEAR FORM button on an entirely
new form that I am making.
--
bob

--
bob

See answer in your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vdmbqb" wrote in message ...
I tried this, but when I press Ctrl-F3 nothing happens. Is that because I am
using Office XP

--
bob


"Ron de Bruin" wrote:

Hi vdmbqb

I love your name<g

Hold your Ctrl key when you select all cells that you want to clear
Then use Ctrl-F3 to give this range a name

You can use this code line then to clear the cells
Range("MyRange").ClearContents


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vdmbqb" wrote in message ...
I have a form written in excel 2003. Every cell on the form is locked except
the cells that require new info each time. For instance, cell A1 reads NAME
and cell A2 is blank and allows you to enter a persons name. At the top of
the form is a button that reads "CLEAR FORM". When you click on the button
all cells that are not locked for editing clear and you can reuse the form
for the next person. I need to recreate the CLEAR FORM button on an entirely
new form that I am making.
--
bob

--
bob