Heres what I do: While worksheet is open, move cursor over tab at bottom of
worksheet your client wants to email; right click on tab, choose "Move or
Copy"; then select "New book", check in lower left on "create a copy"; click
"OK"; now, go to top, choose FILE and SEND TO: and a copy of the 1 worksheet
will email out.

"Carla Bradley" wrote:

I have a client with Excel 2003 and he wants to know if he can email only one
worksheet from a spreadsheet instead of the entire spreadsheet. Only way I
know to do it is lock down the others or copy the one to a blank spreadsheet
and send it or create a macro to do that. Any other ideas because he didn't
like any of those.

Thanks,
Carla