Macro Question

  • Thread starter Thread starter Zaidy036
  • Start date Start date
Z

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
=========================
 
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.
 
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
=========================
Click to expand...

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