Workbook Close not working properly

  • Hi,

    I have a userform that has a button called "Close Book"

    Workbooks("Book 1.02.xlsm").Close False

    The issue I am seeing when if there are multiple workbooks are open, by clicking on close book button it closes all the workbooks and also in the task manger EXCEL32 process is still running.

    I need help with the code which only closes the workbook which has the userform and remaining workbooks stays open.

    Appreciate your help in advance!


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!