software

I am trying to create a control form that has three cells that need to be
self numbering. These numbers would increase by just one number. I do not
want anyone to have to change these numbers but rather the form to do this.

Why don’t you write a formula i.e in the cell A3 (=A2 1) and drag it down
then protect the column A using the option Tools / Protection …. / Protect
Sheet
That will not permit any one to change the data in Column A

Thanks
Maged Elsabagh
quot;cochumquot; wrote:

gt; I am trying to create a control form that has three cells that need to be
gt; self numbering. These numbers would increase by just one number. I do not
gt; want anyone to have to change these numbers but rather the form to do this.

Oh and then hide the first row with the initial number in it?

quot;maged_gizaquot; wrote:

gt; Why don’t you write a formula i.e in the cell A3 (=A2 1) and drag it down
gt; then protect the column A using the option Tools / Protection …. / Protect
gt; Sheet
gt; That will not permit any one to change the data in Column A
gt;
gt; Thanks
gt; Maged Elsabagh
gt;
gt;
gt;
gt; quot;cochumquot; wrote:
gt;
gt; gt; I am trying to create a control form that has three cells that need to be
gt; gt; self numbering. These numbers would increase by just one number. I do not
gt; gt; want anyone to have to change these numbers but rather the form to do this.