Is the workbook protected under ToolsProtection?

If so, unprotect it. You may need a password.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 11:40:00 -0700, Bern
wrote:

I am trying to copy a worksheet but it seems that that option (as well as all
but two options) are locked...I need to copy this worksheet only so I can
email it without the recipient seeing the rest of them.

Bryan