I've been working on a spreadsheet for work and trying to optimize it as a template format that me and my coworkers can use on future projects if the need arises.
I have the spreadsheet and VBA programmed the way i need it. its a single worksheet workbook that is designed for inputing data for one feature (thus why i named the work sheet in the file "rename me" because it is expected the user putting data in the file to lable it appropriatly
I have a simple VBA code in the "Sheet1" of microsoft excel onjects group.
My question is if I rename the sheet tab will it break the code also if i do a "move or copy" and create a copy of it either in a new work book or in the same workbook will it copy the VBA code over so that it works on the copied sheet where ever it goes?
I have the spreadsheet and VBA programmed the way i need it. its a single worksheet workbook that is designed for inputing data for one feature (thus why i named the work sheet in the file "rename me" because it is expected the user putting data in the file to lable it appropriatly
I have a simple VBA code in the "Sheet1" of microsoft excel onjects group.
My question is if I rename the sheet tab will it break the code also if i do a "move or copy" and create a copy of it either in a new work book or in the same workbook will it copy the VBA code over so that it works on the copied sheet where ever it goes?
