Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, i have this macro that save entire workbook at row change.
But this macro is saving entire workbook and it's taking too much everytime i change row. Can this macro be made to save only active sheet? Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Static lngRow As Long If Target.Row < lngRow Then Me.save lngRow = Target.Row End Sub Can this be done? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Macro Will Not Save | Excel Discussion (Misc queries) | |||
save as macro | Excel Discussion (Misc queries) | |||
save as macro | Excel Discussion (Misc queries) | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) |