After searching for some code to make a button visible dependent on cell values, I found some code on here that 'almost works'
3 of the 6 buttons on the sheet could be visible at any time, would appreciate any help tidying up this code to allow.
I thank you in advance for reading.
Darren
Code below:
Please Login or Register to view this content.
Maybe something like this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks, just used that and it doesnt seem to work. I would only need the buttons to appear if the cell value where stated was Y, otherwise would not want the button to appear at all.
Appreciate the help Jerry.
Darren
The syntax given "should work", so I'd need to see your sheet and get a little more detail on using it before I can adjust that suggestion much.
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
Thanks Jerry,
I have highlighted the cells that the code relates to.
Don't believe relevant but row 28 will be hidden once I have the code working.
Appreciate the help.
Darren
The first most glaring error is the "Button" names are completely wrong in your example macro above. So, try this instead:
If I got it backwards, then change the <> in the code above to =Please Login or Register to view this content.
Thanks Jerry, I changed the <> to = as you suggested.
It currently works if I overwrite the "Y" in the cell addresses, ideally I needed the buttons to automatically be visible / non visible based on the cell results (which is a lookup) should that matter?
Darren
Is there a way to add to the code you gave me so that it forces a calulation?
Darren
The worksheet_change event it triggered by manual changes on the sheet somewhere.
If you switch to a worksheet_calculate event instead, then the code even gets a little shorter.
Please Login or Register to view this content.
Perfect! bang on.
Reputation added to!
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks