Hi Jako!

MVPs are not the only people who can reply to your questions. I could name
quite a few non-MVP contributors who have forgotten more stuff on Excel than
I'll ever know. Indeed in expressing your request this way, you are likely
to cut down your responses all round.

But we're tolerant of newcomers!

I'd use Ron de Bruin's SendMail for this task as it allows you to send a
copy of a single protected sheet. If you send it to yourself, you'll find
that you achieved what you want.

See:
Ron de Bruin
http://www.rondebruin.nl/sendmail-addin.htm

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

"Jako " wrote in message
...
I have an application which i want to save just a worksheet and not the
entire workbook.

Can someone please suggest the best way to do this.

I would also like it saved with protection so the contents cannot be
changed but can be copied from.

Any advice appreciated.


---
Message posted from http://www.ExcelForum.com/