Remove VBA codes after copyin sheet to a new workbook

[phoenicx]

I made a quotation template, where I fill in the production steps with time, and a price comes out. I do this for several steps, i.e. milling, grinding etc. In the same book another sheets is fed with the data of this quote that is the production chart that will go in to the factory. When done I made a button "save quotation" which export the quote chart and the production chart to a new workbook and saves it under the drawing number and revision number. I used this code for it:

Please Login or Register  to view this content.

The thing I want now is that in the new workbook I do not want the save button and codes any more. How should I do that?

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[phoenicx]

Changed it.

[phoenicx]

Someone has an answer for me?

[IonutC]

Hi Phoenicx,

In normal fact you shouldn't have the button there.
Try this code:

Please Login or Register  to view this content.

Cheers,
Ionut

[IonutC]

If you have more sheets you can use:

Please Login or Register  to view this content.

[meabrams]

I guess should have completely read what you want it to do, but this will open another excel file and copy info without the vba side to the current excel sheet

Would something like this do what you want

Please Login or Register  to view this content.

[phoenicx]

Besides copying this into my VBA, what else do I need to change in my sheet? Do I leave my original CODE and add this?