I have some columns that auto unhide and when this happens, a prompt message displays to inform the user to complete the next level.
However, whenever the user makes another selection, the prompt box keeps coming back up.
How would I only run the message once?
This is the code I am using and I have attached the sheet,
Please Login or Register to view this content.
Last edited by JonathonHardy; 11-16-2011 at 11:18 AM.
Try this...I think i understand what you are after. Basically, change the order of the operations (prompt then unhide) then you can use and IF statement to only perform the action IF the columns are hidden.
That way, once they are not hidden, the message will not fire again.
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
But, i wasn't sure if this made the sheet function exactly how you want, it does handle the "don't prompt again" part of things
Thank you. That worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks