Autofilter macro once runned, stop and run another macro

**streamofmight** · 11-01-2012, 05:26 AM

Hi

my file's username is username1, password is password1.

For the sheet "Statement of Account', I have an autofilter macro in place. However, I wish to add macro SOA_GST too. The macro for SOA_GST has been written. However, when I run SOA_GST after my autofilter macro has run, the autofilter macro automatically deletes my added in data that is a result of SOA_GST. Please help!

By the way if it's possible I would not wish to have the macro button in my "Statement of Account" sheet. I wrote the macro to run autofilter, stop it, and then run SOA_GST but it didn't work.

**TMS** · 11-01-2012, 05:53 AM

Try changing the SOA_GST macro to this:

Sub SOA_GST()
'
' SOA_GST Macro
'

'
Application.ScreenUpdating = False
Application.EnableEvents = False
Range("D15").FormulaR1C1 = "Total"
Range("E15").FormulaR1C1 = "=SUM(R[-7]C:R[-5]C)"
Range("D16").FormulaR1C1 = "GST"
Range("E16").FormulaR1C1 = "=7%*R[-1]C"
Range("D17").FormulaR1C1 = "Net Total"
Range("E17").FormulaR1C1 = "=SUM(R[-1]C+R[-2]C)"
Application.EnableEvents = True
Application.ScreenUpdating = True
End Sub

Regards, TMS