deleting worksheets from workbook when option not available
 

I am trying to delete worksheets from a workbook and the option for deleting
sheets is not available it is greyed out. Is there anything I can do to make
that option available.
Thanks,
Rita318

deleting worksheets from workbook when option not available
 

Hi Rita

Is the workbook protected? Go ToolsProtection and look to see if you
have an Unprotect option. You would need to click that before you can
delete the sheets.

Hope this helps!

Richard


Rita318 wrote:

I am trying to delete worksheets from a workbook and the option for deleting
sheets is not available it is greyed out. Is there anything I can do to make
that option available.
Thanks,
Rita318

deleting worksheets from workbook when option not available
 

It sounds like the workbook is protected so un-protect it

Mike

"Rita318" wrote:

I am trying to delete worksheets from a workbook and the option for deleting
sheets is not available it is greyed out. Is there anything I can do to make
that option available.
Thanks,
Rita318

deleting worksheets from workbook when option not available
 

Rita

Also, if the workbook is Shared you cannot delete sheets.

Do you see [Shared] in the title bar?


Gord Dibben MS Excel MVP

On 4 Jan 2007 05:58:25 -0800, "RichardSchollar"
wrote:

Hi Rita

Is the workbook protected? Go ToolsProtection and look to see if you
have an Unprotect option. You would need to click that before you can
delete the sheets.

Hope this helps!

Richard


Rita318 wrote:

I am trying to delete worksheets from a workbook and the option for deleting
sheets is not available it is greyed out. Is there anything I can do to make
that option available.
Thanks,
Rita318