Forms

[Rosie]

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?

 

[Gord Dibben]

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.

Button>Excel Options>Customize>Choose commands from>All commands.

Scroll down to the padlock and add it to the QAT


Gord Dibben MS Excel MVP