Hi,
I would like to use a shape to operate some conditional formatting on a sheet.
I wont to use a shape purely because it matches the appearance of some other shape/buttons I have in place.
I currently have a Command Button VB code which operates conditional format.
Is it possible to replace the command button with a shape/button and code to do the same thing please?
Help as always is much appreciated.
Many thanks
Hi A440,
Add the shape (Insert really) onto the worksheet and assign the macro to it that the command button is now triggering. Then Cut the command button off the sheet and that should do what you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Yes, place the shape you want, where you want on the sheet then right click it and select Assign Macro....Yea, what Marvin the Martian said
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi,
Just create the following macro and attach it to the shape button.
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.
Thank you Richard, just the job
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks