Hello,
I am a little rusty on my macro skills and need some pointers on where to get started on a project I have undertaken at a new job.
We have a excel file template we created for purchase orders that I have to manually go into and change the PO# in a cell, protect the worksheet, and then save it as the PO#. I have to create a large amount of these at once so other people can use the protected sheets.
I was hoping I could find a way to have at the very least the main template have a macro that would auto create a new workbook based on the template, fill in the necessary number, and then save the file as that number. If I could have a pop up or just somewhere on the template workbook where I list the beginning and ending number and it created each file that would be ideal.
I am not sure how protecting a workbook works with macros.
Thank you in advance for any help.
I am a little rusty on my macro skills and need some pointers on where to get started on a project I have undertaken at a new job.
We have a excel file template we created for purchase orders that I have to manually go into and change the PO# in a cell, protect the worksheet, and then save it as the PO#. I have to create a large amount of these at once so other people can use the protected sheets.
I was hoping I could find a way to have at the very least the main template have a macro that would auto create a new workbook based on the template, fill in the necessary number, and then save the file as that number. If I could have a pop up or just somewhere on the template workbook where I list the beginning and ending number and it created each file that would be ideal.
I am not sure how protecting a workbook works with macros.
Thank you in advance for any help.