WalkerEvans
Technical User
I have given up trying to work this one out for myself. There must be an answer to this somewhere in the Excel Help files, but many days of searching there (and here) have left me with nothing but a dull ache behind my eyes.
Is it possible to launch a macro from a cell? One of my users approached me for a simple change to a macro so that the user could add more lines. Writing the changes to the macro was easy, but I'd like to set it up so that, when the user enters the last cell, she would be given a choice whether or not to add more lines. A "Yes" answer would launch the macro.
If this can't be done (and I'm beginning to believe it can't) I can always give her a command bar button, but it would be neater to automate if possible. Any ideas out there?
Thanks for any help you folks can give me on this!
Is it possible to launch a macro from a cell? One of my users approached me for a simple change to a macro so that the user could add more lines. Writing the changes to the macro was easy, but I'd like to set it up so that, when the user enters the last cell, she would be given a choice whether or not to add more lines. A "Yes" answer would launch the macro.
If this can't be done (and I'm beginning to believe it can't) I can always give her a command bar button, but it would be neater to automate if possible. Any ideas out there?
Thanks for any help you folks can give me on this!