on close

  1. B

    How to stop combo box from running on close

    Hi, I'm using Excel 2007 and I've spent a number of days to figure this out and it just keeps on popping up despite my best efforts. I've written a number of functions and subs that work when I change combo boxes as they should. When I think I'm done and then I try and save as, save or just...
  2. C

    On Close Code

    I was trying to figure out a code that I can use. I want to use a macro or a code on close for the following. We do our invoices on Excel. I want to create a back order sheet if the value's for Column I say BO. I want it to copy the values in columns A & B for each item that has BO in Column...
  3. G

    Don't save when user closes workbook

    Is there a line of code that I could throw into my workbook that will not save any changes when the user closes the file? I have a shell spreadsheet that runs a macro, populates the sheets with external data, and changes the names of the sheets. The data that is populated is for visual...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top