hi my name is ramesh from India.
no worries, I found an old post of yours an muddled through . (it adds another sheet to a workbook, pretty cool). I'm trying to make a pop up to select sheets to be emailed. similar to the 'print selected pages' pop up floating around on this site. i'm now stumped on how to select all check boxes at the same time. on the form i have 4 or 5 check boxes and an email button so far, next is most likely a cancel box which i'll look to your old post for assistance. do you have any examples of how to select more than 1 checkbox at once available? or a link to a good example? i've googled several terms but haven't found anything relevant. I can upload the form if it will help explain what i'm looking for. thanks again, brian H
Hello Brian, I have been busy the past couple of days. I will pull something together for you tomorrow. Sincerely, Leith Ross
Hi Leith and thanks for your help, i think Pop up sounds better! . should i post this on a forum to not break any rules?
Hello Brian, I can provide you with an example workbook that has all the code to setup and remove the right click menu. Another option may be adding a pop up menu to your menu control. This would give you even more flexibility and a more professional appearance. Let me know how you want to proceed. Sincerely, Leith Ross