These functions work to answer the OP directly but I'd really like to finish it a bit with a 'Modal Form' effect. Let me know if you need help applying these in your workbook. I figured that since you already have the macro assigned in the shape that using these would come easy enough.
Just change the name of the shape in the worksheet "Name" or change the quoted names below to what you are using.
I may still add more on this someday but I wanted to get you your solution rather than try to add mine too. LOL
Happy Day!!
K
Bookmarks