Hello,
I have inserted a macro button and have assigned the macro to it. It's currently a blue colour, however after the macro has run, I would like it to turn Green and say Macro completed - so the user knows the macro has run and not to click the button again.
Attached is the example :-)
I would like to know how to manually do this, not write the code.
I would like to know how to manually do this, not write the code.Please explain further
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi,
Your request is ambiguous. You start by saying that you want the macro to paint the button green but then go on to say you want to know how to do it manually.
I'm presuming you do want the macro to do it so...
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Why not use the cells behind the macro as a color coding scheme to let them know it has or has NOT been run.
I cant really follow what you are asking for.
Originally Posted by Loz44
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Sorry I meant how to this using the macro recording & formatting. I'm not a master at writing VBA codes
Ok thanks I'll try both your suggestions. Obviously I'm not good at explaining the right terminology!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks