Hi all,
I have searched through the forum for something in VBA to accomplish this... but, so far no luck. I don't remember near enough of my VBA classes to dig myself out of this one. (I volunteered to get this done...)
What I need is a worksheet that I can open, click a button that generates a page worth of sequential numbers (or perhaps multiple pages, depending on how many numbers a user needs, if that's an option). Would love it if the print function could be called up so you can print the new numbers, then somehow lock or delete the numbers once printed. Would need the list of numbers to start after the last number generated last time...
The ultimate goal of this is to have a set of numbers generated so that anyone can get the next set without worrying if the last person remembered to black out or delete the previous set printed.
This is what we work with now. Its all manual, and if you forget to block out the numbers you use, someone else will use the same ones and will overwrite files stored in a network location for our cutting laser in the shop... We've had some close calls already. We print this off and fill out the rows as we use the numbers. We would rather not change the form and usage, just make it a little more fool proof for multiple users.
Thanks in advance to whoever has the know-how!
G_tech
I have searched through the forum for something in VBA to accomplish this... but, so far no luck. I don't remember near enough of my VBA classes to dig myself out of this one. (I volunteered to get this done...)
What I need is a worksheet that I can open, click a button that generates a page worth of sequential numbers (or perhaps multiple pages, depending on how many numbers a user needs, if that's an option). Would love it if the print function could be called up so you can print the new numbers, then somehow lock or delete the numbers once printed. Would need the list of numbers to start after the last number generated last time...
The ultimate goal of this is to have a set of numbers generated so that anyone can get the next set without worrying if the last person remembered to black out or delete the previous set printed.
This is what we work with now. Its all manual, and if you forget to block out the numbers you use, someone else will use the same ones and will overwrite files stored in a network location for our cutting laser in the shop... We've had some close calls already. We print this off and fill out the rows as we use the numbers. We would rather not change the form and usage, just make it a little more fool proof for multiple users.
Thanks in advance to whoever has the know-how!
G_tech
