LinkBack URL
About LinkBacks
Hi Everyone, i'm not sure if this is possible but i'm looking for a code where:
If button is clicked more than once a day then do nothing
else run code
Thanks
Hi Everyone, i'm not sure if this is possible but i'm looking for a code where:
If button is clicked more than once a day then do nothing
else run code
Thanks
Hi there,
Try the following code and see if it does what you need:
Hope this helps - please let me know how you get on.
Please Login or Register to view this content.
Regards,
Greg M
Hi,
Your information is too simple to answer your question.
If the button belongs to your ADDIN, you can do it in buttonclick callback.
If the button belongs to EXCEL, you may advise an event to the button.
You have to remember the datetime of last click. Maybe you also need button id as the click happens in different process in one day.
Cheers,
Last edited by neu_stone; 08-21-2015 at 04:26 PM.
Thanks Greg, this works great...however, how can this code run for specific button? i mean, i have 2 buttons on the sheet Button1 and Button2. Want this code to work for Button2 only.Originally Posted by Greg M
Hi there,
Try the following code and see if it does what you need:
Hope this helps - please let me know how you get on.Please Login or Register to view this content.
Regards,
Greg M
Thanks again!
Last edited by biznez; 08-21-2015 at 05:02 PM.
Hi again,
Many thanks for your feedback and also for the Reputation increase
Assign the RunOnceDaily routine only to Button2 (left click on Button2 >> Assign Macro >> select RunOnceDaily from the dropdown list), and assign your other "multiple daily runs" routine to Button1. Anything else, feel free to shout!
Best regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks