Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Macro for Undo (Excel 2002/2003)

    Hi

    I have a worksheet where a macro places items into cells that are protected to prevent manual entry, the macro finds the next empty cell in the column to add the selection.

    So say if B7 is the first cell then that is where the first item is added, then then the next selection will be added to B8 and so on.

    However if the user makes a wrong entry because of the protection he or she cannot remove it. I tried to create a maco to undo the last action but with no success.

    Any ideas please.

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Macro for Undo (Excel 2002/2003)

    Hi

    I have resolved this problem here: http://www.j-walk.com/ss/excel/tips/tip23.htm

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •