Active x button code

[Skyfawn]

Just looking for the final piece of the puzzle to finish my excel diet planner
I Would like to use an active X button to save several worksheets to a new workbook
The specifics are,
I would need it to "Save as" so it asks me for the name of the new workbook and where to save it.
The Sheets I would be saving are (in order) "Monday" "Tuesday" "Wednesday" "Thursday" "Friday" "Saturday" "Sunday" "Weekly Diet Sheet"

Thanks for any help.

[Logit]

.
Are these sheets the only ones in the workbook ?

"Monday" "Tuesday" "Wednesday" "Thursday" "Friday" "Saturday" "Sunday" "Weekly Diet Sheet"

[Skyfawn]

No, there are also sheets called "Meal Planner(Day)", "Food Items" and "Calculations" and I may also be adding another Sheet soon that will be called something along the lines of "Information"

[dangelor]

Possibly...

Please Login or Register  to view this content.