Copy entire worksheet including all Macros and VBA Code

I am sure this is simple, but I don't know how to do it.
I need to copy my worskheet multiple times to create about 10 of the same worksheets within a workbook. I know if you click in the very most top left hand corner of the worksheet, then click copy, go to the new worksheet and click paste, it copies the whole page, but it does not copy over the VBA Code. Also, for some reason, it does copy over my macro buttons, but does not put some of them in the right spot?

Any help on this would be greatly appreciated

Try

Please Login or Register  to view this content.

The code goes in a code module.

1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

Then do Alt+F8 from Excel, scroll down and select the macro copySht, and press Run.

A virgin workbook has two kinds of modules: One ThisWorkbook module, and a Sheet module for each sheet. Those modules are special in that they support processing of workbook and sheet events.

To that, you can add any number of Code modules. Code modules are not associated with any particular sheet. This code goes in a code module.