Button to copy, save a sheet in a new file

[JohnB]

Hi to all of You,
I have an Excel file with 5 sheets.
Is there any way of adding a 'save' button that allows a copy of the
calculator sheet to be saved without the background information added
(formula's etc) but also keep the formatting as it is, I need to be able to
provide copies of the sheet for accounts but I don't want them to have
access to the whole sheet?
The sheet is named "Calculator" and if possible when I saved I would like as
name the content of cell F2. The range C1:R140.

Thanks for your help.
Regards
John

 

[Don Guillett]

Hi to all of You,
I have an Excel file with 5 sheets.
Is there any way of adding a 'save' button that allows a copy of the
calculator sheet to be saved without the background information added
(formula's etc) but also keep the formatting as it is, I need to be able to
provide copies of the sheet for accounts but I don't want them to have
access to the whole sheet?
The sheet is named "Calculator" and if possible when I saved I would likeas
name the content of cell F2. The range C1:R140.

Thanks for your help.
Regards
John

Have a macro clear the UN wanted range>
If you right click the sheet tab>move copy>copy>NEW book
Incorporate into your macro
"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

 

[JohnB]

Thanks to all of You for your precious suggestion.
Almost done.

Regards
John