I'm trying to make it so every time a user adds a new sheet to an existing Excel workbook, that sheet has specific information already on it (such as labels for where to put certain data, etc.)
I found a way that seems to be able to change the default sheet layout for ALL future Excel workbooks (by changing the XLSTART files), but I don't want to change the default sheet for all future workbooks, just the layout of new sheets added to one particular workbook.
I can whip something up in VBA too if need be, but I'm not even sure where to start.
Can anyone suggest how I might be able to set a default sheet layout for a particular Excel workbook?