VBA Save as - save 1 sheet and no code?

Is it possible to set up an option for a user to Save As where it will only save a particular sheet in the workbook and will not save any forms, code, or anything else except the data that is on that sheet at the time of the save? Thanks!

Hi ker9,
There is a command that is not on the normal toolbars called Export Range to File...
You need to customize your toolbar and add it as an icon and try it out.
I believe it has many formats it will save as.
Search the net for "Excel Export Range to File" and see how others do it.

I hope that helps.