| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to copy, save a sheet in a new file
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a button to SAVE a sheet | Excel Programming | |||
| save only active sheet Button. | Excel Discussion (Misc queries) | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| Need help, Seq numbers, Save filename & A button on sheet. | Excel Discussion (Misc queries) | |||
| How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
![JohnB[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
