| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a macro to save worksheet
I am currently looking for a way to prompt users to save a copy of a
worksheet into a location of their choosing (same as doing "FIle", "Save As"). This is what i have so far: Sub Copy_Save_OneDay_Sheet() ' ' Copy_Save_OneDay_Sheet Macro ' Macro recorded 11/17/2006 by ISD ' ' Sheets("Roster(1 Day)").Select Sheets("Roster(1 Day)").Copy End Sub Can someone help? Thanks -- Dwayne |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing a macro to save worksheet
If you make the Workbook "Read Only" they will be forced to do "Save As".
-- Best wishes, Jim "Dwayne Hodges" wrote: I am currently looking for a way to prompt users to save a copy of a worksheet into a location of their choosing (same as doing "FIle", "Save As"). This is what i have so far: Sub Copy_Save_OneDay_Sheet() ' ' Copy_Save_OneDay_Sheet Macro ' Macro recorded 11/17/2006 by ISD ' ' Sheets("Roster(1 Day)").Select Sheets("Roster(1 Day)").Copy End Sub Can someone help? Thanks -- Dwayne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| writing a macro to save a workbook | Excel Worksheet Functions | |||
| Macro Save with Worksheet as file Name | Excel Programming | |||
| Macro to Save worksheet to new document | Excel Programming | |||
| wRITING A mACRO TO MAKE A WORKSHEET PRINT. | Excel Programming | |||
| Macro to save worksheet | Excel Programming | |||
Hybrid Mode
