Macro for closing a workbook

[Harvey12]

Hi All,

I am unsure if this is possible so I will do my best to explain what I am looking for!

I am trying to write a macro which can close a workbook after another macro has been ran.

The first macro runs this unhides a selection of tabs, this is controlled through the click of a command button that runs that macro, this works fine. The next challenge is that I need that macro to be followed by some further code that will close the workbook, once that macro is complete, and only if that macro is run.

The file automatically saves itself.

Can someone please assist.

Many thanks
Harvey

 

[Fishboy]

Hi Harvey12,

Can you not just add this line to the end of your current code?

Workbooks("WORKBOOK NAME.XLSM").Close

 

[Harvey12]

Hi Fishboy,

Thanks for such rapid response, I am actually asking on behalf of someone and apparently I've asked for the wrong thing!!

What he wants to happen is once the macro has been run to unhide all of the worksheets, when someone attempts to close the workbook a message box needs to pop open, essentially he is looking for a way for another macro to run ONLY IF that macro to unhide the sheets has been run, otherwise if the sheets have no been unhidden he wants the file to close in the normal fashion?

Many thanks
Harvey