How do I do this? I only want the user to use the mouse when one of my yes/no msgboxs comes up in the code. Some just enter through without realising.
The below lines work for a workbook, but need it to work only when the msgbox is up so the user cant press ENTER.
e.g.
Help, this should be simple??
Please Login or Register to view this content.
I reckon you'd need api calls to do that but you could use a userform instead of a msgbox statement or add a non-functioning Help button and make it default
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Second person to suggest using a help button as a default trap. Tried it.........and it actually works quite well. Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks