Issues with saving current worksheet without macros, conditional, formulas + email in Lotus

csimonds

Board Regular
Joined
Oct 2, 2011
Messages
73
Hi,

I have a spreadsheet set up as an order form. The orders are entered within a table, the table contains 3 dependent drop downs across 3 columns. I have a "Submit" button, which prompts the order form to be emailed using Ron de Bruin, Lotus Notes: Send the active sheet as an attachment http://www.rondebruin.nl/notes7.htm. What I am wanting this code to do is save a copy of the spreadsheet in a defined folder, removing macros, formulas, buttons and dropdowns. This should be the same format for the file then emailed, (currently the code emails the spreadsheet as is with macros etc.). I would then like the code to close the original spreadsheet without saving.

Any assistance would be greatly appreciated.

Thank you
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Sal Paradise

Well-known Member
Joined
Oct 23, 2006
Messages
2,457
Hi,

I have a spreadsheet set up as an order form. The orders are entered within a table, the table contains 3 dependent drop downs across 3 columns. I have a "Submit" button, which prompts the order form to be emailed using Ron de Bruin, Lotus Notes: Send the active sheet as an attachment http://www.rondebruin.nl/notes7.htm. What I am wanting this code to do is save a copy of the spreadsheet in a defined folder, removing macros, formulas, buttons and dropdowns. This should be the same format for the file then emailed, (currently the code emails the spreadsheet as is with macros etc.). I would then like the code to close the original spreadsheet without saving.

Any assistance would be greatly appreciated.

Thank you

Why don't you copy the data (values) and formats to a new sheet? That shouldn't copy the dropdowns, and the sheet would look the same, but since it's a new book it wouldn't contain any code or formulas, just the final info.

So the general code would be:
- Once submit is hit
- Copy values, paste special to new sheet
- Copy formats, paste special to new sheet
- Save new sheet as whatever file name in whatever folder
- E-mail new sheet
- Close original sheet without saving
 

Watch MrExcel Video

Forum statistics

Threads
1,130,169
Messages
5,640,550
Members
417,151
Latest member
ChickenTenderer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top