Help with when YES has been clicked the code will no longer show again.
Hello, i have a code which tells me when a person is close to their course.
It will ask then within 14 days of the course whether i have booked them transport.
What i would like is that if they click YES, i want this code to no longer run each time i activate the sheet.
However if they click no, for it to still activate until they click YES.
Here is the code i have.
Kind regards,
Please Login or Register to view this content.
Kyle
Have a second sheet in the workbook with an attribute of xlveryhidden. In cell A1 of this sheet, record LResponse. Check this cell before executing the code. if it is vbyes, then don't execute the code.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks