Macro Button to move 2 tabs to a new workbook

Hi All,

I've went through the website and have found numerous threads in regards to this, but none seem to be working specifically for what I'm trying to accomplish.

I have a workbook with approximately 50 tabs and various macros throughout the workbook. I have two tabs (Billing Sheet & Review Tab) that have references to other tabs that I need to be able to extract and save to desktop as a new name based on cells in the inputs tab --- Basically "Billing + Review Sheet for Inputs!e23"

I would like a button on both the billing and review tabs that would initiate this macro. I also would like to keep the formatting, while getting rid of the references (basically a copy/paste without formulas). The review tab has a bunch (60) checkboxes that also need to be exported. I would like to keep the macros from the workbook to the new workbook, because I also have a "Print to PDF" macro that I would like to still work.

What I currently have -- just essentially selects the two sheets and then saves the entire worksheet.

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks!!
Travis

I'm getting a 400 error. The workbook is created, but tabs don't delete.

Almost yes to all of those. I have a userform when the workbook opens for the first time (referenced by a specific cell in the inputs tab). This userform dumps data into the inputs tab.

Please Login or Register  to view this content.

The two sheets are also protected (without a password).

The code does replace the formulas with values on both sheets before it errors.