Lewej23
02-23-2012, 11:43 AM
I've got a workbook that I created in Excel and I don't want the end users to insert or delete worksheets... I know enough about VBA to tinker around with it a little. But not enough to really know what I'm doing.
My questions:
1. Where do I put all this code? I know to go to the Developer tab and go to View Code, but do I select one of the sheets or the "ThisWorkbook" under the Excel Objects or start a new Module?
2. How is the entire code set up? I know you need to start it out with "Sub" or "Private Sub" and it needs to end with "End Sub", but I don't know exactly what to use.
Thank-you!
My questions:
1. Where do I put all this code? I know to go to the Developer tab and go to View Code, but do I select one of the sheets or the "ThisWorkbook" under the Excel Objects or start a new Module?
2. How is the entire code set up? I know you need to start it out with "Sub" or "Private Sub" and it needs to end with "End Sub", but I don't know exactly what to use.
Thank-you!