Can Worksheet.add do tab names, buttons, and VBA code?

[KevH]

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.

 

[KevH]

Sweet,

You even saved me from having to remind myself how visible worked... moments after I reminded myself how visible worked.

 

[Davers]

Heh...I agree KevH...Norie has helped me many times! In fact, there's a good chance he helped me with the above code! This forum has quite a few rock stars who help out!! Norie, NateO, and Anne just being a few that have helped me with projects through the years!!! Good luck on your projects!

Cheers!

Dave