How do I write a macro that will re-number a spreadsheet every time it is opened? I want to have this purchase order worksheet automatically re-number every time it is opened, because different people will be opening it so I want the action to be automatic.

Also, how do I handle the situation where a sheet is opened, but is discarded (so I don't want it to renumber)?

I would appreciate any help out there.

Thanks.

Susan