rollback

  1. A

    SQL transaction equivalent in SQL

    Hello, I'm relatively new to VBA. Sometimes I'll run a macro that has a mistake i it and it messes up my whole worksheet. Undo doesn't work in these cases, and if the sheets has been saved during the macro, I can't just close and reopen the workbook to the last saved place. Is there some sort...
  2. R

    roll back excel 2007 macro to work on excel 2003

    hi all I have made an excel gantt chart using macros based on conditional formatting, in excel 2007. what I would like to do is use it on excel 2003 however I am struggling to rewrite the macros to allow approximately 70 conditions per cell with various colours. this is a sample of what...
  3. E

    Macros on Individual Files Rolled Back?

    Hi everybody, I'm new to posting in forums but I can't understand what just happened so I'd like to see if anybody can explain the "why" and the "how to keep it from never happening again". At my work we have a workbook with several macros in it to perform table operations (basic reformatting...
  4. R

    Learning Do-Until Loops

    Hi there! I'm trying to learn how to use VBA's Do-Until looping function to assist me in getting a payment rollback feature to work. I have a very simple workbook created that calculates a monthly payment based on the standard set of PMT Arguments. What I'm trying to do is get an input box...
  5. NuJoizey

    Cancel change event?

    A user mistakenly clicks a checkbox from False to True. I want a message box to pop up saying "Are you sure?" If user responds "NO" then I want to exit out of the routine and set the checkbox back to False. But the problem is that when I do this, the event is re-fired and AddCols() procedure...

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