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
Bookmarks