Macro Question

[Zaidy036]

Win 7 Home Premium 64 bit SP-1, Excel 2007

I have the following Macro run by an icon in the QAT

The icon must be clicked twice to function. How can I change it to work
on a single click?
===========================
Sub SaveAndCloseAll()

Dim WB As Workbook
For Each WB In Workbooks
WB.Save
WB.Close
Next WB

End Sub
=========================

 

[kumarapush]

I wonder what is QAT? Is it something like any testing tool?
If possible please share the Excel that you have issue, so that more people would try to solve it.

 

[Zaidy036]

Win 7 Home Premium 64 bit SP-1, Excel 2007

I have the following Macro run by an icon in the QAT

The icon must be clicked twice to function. How can I change it to work
on a single click?
===========================
Sub SaveAndCloseAll()

Dim WB As Workbook
For Each WB In Workbooks
WB.Save
WB.Close
Next WB

End Sub
=========================

Anybody have an idea? Is this normal and not fixable?