I am working on a spreadsheet that I use to figure an inventory results. I
need to email only part of the information. I have thought of two methods to
acheive my result. One is create a macro that would delete the un-needed
worsheets and save the file to a new name. My other idea was to just create
a macro that would just hide the un-needed and show the sheets that our
accounting department needs for their records. Any suggestions on how to
best get this done