I have a FORM CONTROL in my worksheet.
Example:
I have (3) Buttons (Form Control) in Sheet1, each buttons have macro on it when they've been click.
The problem is I want to DISABLE the functionality of the (3) Buttons when the user click it.
Named:
btn1
btn2
btn3
NOTE:
Developer tab -> Insert -> Buttons (Form Control)
Attachment:
SampleWorksheet.xlsb
Last edited by mcmunoz; 09-20-2013 at 02:58 AM.
try this for the first button n see if it helps you
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Nothing happened. Still the macro of the button working.Originally Posted by john55
try this for the first button n see if it helps you
Please Login or Register to view this content.Can you make a sample in my attachment?
try the sample attached
I recommend hiding the button instead, because the above mentioned code was depreciated with Excel 2010.
Please Login or Register to view this content.
Hi jrtraylor,
I appreciate your advice, I'll keep in mind for future!
mcmunoz, I am sorry I did not know about that (see the option of jrtraylor), now it's your choise.
I've had good intentions.
cheers
Last edited by john55; 09-20-2013 at 01:45 AM.
Thank you guys for helping me, John and JrTraylor
I will use button.visble = False. Because I read some thread that in Excel 2010 even though Button set as Enabled=False still the macro will be trigger when the button is click.
Reference: http://answers.microsoft.com/en-us/o...d-1421209aad98
I will make this problem thread as solve. Using alternate solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks