Read my post #6, it's really hard to do this if I can't see the actual workbook. I'm looking at your PDF that you sent. Look at the PDF. At the top on the left you have a box that says Calendar(UserForm) next to it is one that says UserForm1(UserForm). Down at the very bottom you have two property boxes that both say Calendar UserForm, now look at my post #6. I'm trying to figure out what you did. If you have a userform and you named it calendar and you have a calendar named calendar, this is not a good idea. Normally I just leave my userform named userform1 whatever it happens to be. Nobody sees this it's just a name, but with code you name multiple things calendar and then try to refer to them in code it gets confusing. So since you won't share the actual calendar with me I'm trying to figure out what you did by your pictures.