I don't understand what you mean by lock and unlock a form.

Do you mean the yellow padlock icon that locks and unlocks cells?

It was on the Formatting toolbar in 2003.

In 2007 the padlock can be placed on the QAT.

ButtonExcel OptionsCustomizeChoose commands fromAll commands.

Scroll down to the padlock and add it to the QAT


Gord Dibben MS Excel MVP

On Mon, 22 Feb 2010 12:15:01 -0800, Rosie
wrote:

In 2003 you could lock and unlock a form by toggling on the gold lock in the
Forms Toolbar. In 2007 it seems to be much more complicated. Is there a
simple way to do it?