Comman Button to Save Worksheet as Workbook
OK, I would like to thank you all for making this such a valuable
resource.
Here is my question.
I need a macro that when I click on a command button it will save the
current worksheet (not the workbook) as a file based on the contents of
2 cells.
For example.
WorkSheet = 8
c9 = Name
d3 = Date
When you click on the button it will save Just the current worksheet
(8) as Name_Date.xls
Any help is greatly appreciated.
Thanks,
-T
|