| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save Macro
I'd like a macro that, prior to saving the current workbook, would position
the cursor in cell A1, and make the first sheet the active one. The following code does not work. Can anyone help? Public Sub SaveWorksheet() Dim wrksht As Worksheet For Each wrksht In ActiveWorkbook.Worksheets Range("A1").Select Next wrksht Worksheets(1).Select ActiveWorkbook.Save End Sub Sprinks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| save as macro | Excel Discussion (Misc queries) | |||
| Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
| ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
| Prompted to save changes after macro save - why? | Excel Programming | |||
Threaded Mode
