I Need help edit macro

[etheer]

hi my friend plz help me i need edit this macro RefreshAll and auto save every 5 min

Sub auto()
'
' auto Macro
'
' Keyboard Shortcut: Ctrl+j
'
ActiveWorkbook.RefreshAll
End Sub

 

[wigi]

You could use:

Sub auto()'
' auto Macro
'
' Keyboard Shortcut: Ctrl+j
'


    With ActiveWorkbook
        .Parent.AutoRecover.Enabled = True
        .Parent.AutoRecover.Time = 10
        .EnableAutoRecover = True
        .RefreshAll
    End With
    
End Sub

If I look at your previous topics and posts, I would like to ask you to be more specific and helpful towards helpers.
Also, please use

 tags even for short macros. Thanks.

 

[etheer]

thank you
i need code RefreshAll and after five minutes save




Sub auto()
'
' auto Macro
'
' Keyboard Shortcut: Ctrl+j
'
ActiveWorkbook.RefreshAll
End Sub
Sub sort()
'
' sort Macro
'
' Keyboard Shortcut: Ctrl+l
'
ActiveWorkbook.Save
End Sub

 

[wigi]

Change the number 10 in my code in 5. I wish life was always as simple as that.
Again, the question to use

 tags. Thanks.

 

[etheer]

not work this code


Sub auto()' ' auto Macro ' ' Keyboard Shortcut: Ctrl+j ' With ActiveWorkbook .Parent.AutoRecover.Enabled = True .Parent.AutoRecover.Time = 10 .EnableAutoRecover = True .RefreshAll End With End Sub</pre>

 

[etheer]

plz help me