ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert Worksheet "greyed out" (https://www.excelbanter.com/excel-discussion-misc-queries/164255-insert-worksheet-greyed-out.html)

Kingbaz

Insert Worksheet "greyed out"
 
I am trying to insert a new worksheet into an Excel 2003 workbook, but when I
click "insert" on the toolbar the "worksheet" option is greyed out. All other
otopns are available.

Any idead?

Gord Dibben

Insert Worksheet "greyed out"
 
Sounds like the workbook is protected under ToolsProtection.

You may have to supply a password.


Gord Dibben MS Excel MVP


On Wed, 31 Oct 2007 10:47:03 -0700, Kingbaz
wrote:

I am trying to insert a new worksheet into an Excel 2003 workbook, but when I
click "insert" on the toolbar the "worksheet" option is greyed out. All other
otopns are available.

Any idead?



[email protected]

Insert Worksheet "greyed out"
 
Is the workbook protected?

On Oct 31, 12:47 pm, Kingbaz
wrote:
I am trying to insert a new worksheet into an Excel 2003 workbook, but when I
click "insert" on the toolbar the "worksheet" option is greyed out. All other
otopns are available.

Any idead?





All times are GMT +1. The time now is 04:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com