Howdy all,
Thanks to the archive I was able to find a way to add worksheets and prepopulate some of the cells.
http://www.mrexcel.com/archive/VBA/6439.html
I was wondering if there is also a way to:
- set the name for the tab
- add a command button
- add the underlying VBA
I'm guessing the tab name is easy, but following what I can from the help files results in compile errors.
Thanks to the archive I was able to find a way to add worksheets and prepopulate some of the cells.
http://www.mrexcel.com/archive/VBA/6439.html
I was wondering if there is also a way to:
- set the name for the tab
- add a command button
- add the underlying VBA
I'm guessing the tab name is easy, but following what I can from the help files results in compile errors.