Copy method of worksheet class failed - Please Help

[heanhan]

Hello all the masters in VBA, this is my first post to ask question, but this site is not new to me. I have been absorbing knowledge from all your master posts for very long time. I greatly appreciate all your time and hard work to help people like me who know very very little about VBA code. Without your help, our life will be so painful. I really mean it.

Ok. Here comes with my first question for the form. I "built" a useform for people to fill up some information. The way I designed is that they are able to "merge" data from "sheet2" to a "Master" sheet and then Email the "Master" sheet to via outlook.

However, it is not working the way I wanted. The error message "Copy method of worksheet class failed" keeps coming up... when I clicked "Debug", the following highlighted - Sheets("Master").Copy
I tried many solutions via google around and search into this site. None of them is working. So please help me! I really appreciate your time for this.

Please Login or Register  to view this content.

[TMS]

Your code works for me. Is the sheet protected with a password?

[heanhan]

Thank you for replying. It is protected... and "master" is hidden, I believe this is the problem.

Wondering if there is any way make it hidden and still be able to send email attached.

Thanks