|
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 |
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 |
| All times are GMT +1. The time now is 02:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com