I have a protected form for users to fill out in Excel which has a
requisition # in the top right cell... I want the requisition # to change to
the next increment in the series each time the worksheet is opened... that
way, the next user automatically has the new requisition # on the form when
it is printed.

The Requisition # starts with M1000 and I want it to change to M1001 the
next time it is opened, then M1002 the next time... etc.

Thanks,