Hi all. Is it possible to add code to this..
Sub CopyPasteBuildingServices()
'
'
Range("V4").Select
Selection.Copy
Range("V6:V428").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub
that would change the macro button background color from the default grey, to a different color? The Macro button is currently located in cell V5.
I'd appreciate any assistance!
Yes and No.
First No you cannot change the colour of a Macro button.
However you can replace the Macro button with a shape from the Drawing tab.
You can change the colour of that at will.
Please Login or Register to view this content.
Last edited by mehmetcik; 05-28-2021 at 04:11 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
An activex button can be created, then the background color can be changed:
Please Login or Register to view this content.
Last edited by a2b1c1d1e1f1; 05-28-2021 at 04:00 PM.
If you use an ActiveX button you can
I do it in a few of our reports so that the user knows the process has completed, i change the color to green when done.
Attachment 734561
using something like this
ActiveSheet.CommandButton1.BackColor = RGB(120, 105, 2)
depending on what your button name is.
If you find the suggestion or solution helpful, please consider adding reputation to the post.
mehmetcik .Thank you for your reply. Do I add the code you suggested to my existing code?
You should change your code also.
For values only, change the code in your first post to
and for copying everything, incl formatting, possible formulae and whatever, change toPlease Login or Register to view this content.
Minimize selecting as much as possible. It is seldom required.Please Login or Register to view this content.
Create a shape. Rectangle, circle, hexagon whatever.
Start your macro recorder.
Record yourself clicking on the shape and changing its colour to red then white then blue.
Right click on your shape and use assign macro to point to your recorded macro.
Now edit your macro to change the macro to each color in turn.
That should teach you enough to get you started.
Thank you mehmetcik, your suggestion solved my issue. I appreciate it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks