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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook_Beforeclose 11
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Dynamically assign macro 23
function with collection of custom objects as results 0
Error message 1004 2
How to call Macro(using ExecuteExcel4Macro) for a particular workbook 6
Macro to import multiple sheets 2
Excel Macro to Open and Print Multiple PDF Files 6

Back
Top