ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I add a worksheet when "Worksheet" is dimmed (https://www.excelbanter.com/excel-discussion-misc-queries/84613-how-can-i-add-worksheet-when-worksheet-dimmed.html)

Haddock

How can I add a worksheet when "Worksheet" is dimmed
 
In an Exel Workbook that has 11 sheets so far,
I need to add another worksheet but the word "Worksheet" is dimmed under the
"Insert" tab.
How can I add a new sheet?

Bob Phillips

How can I add a worksheet when "Worksheet" is dimmed
 
Your workbook is probably protected, so unprotect it
(ToolsProtectionUnprotect Workbook...)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Haddock" wrote in message
...
In an Exel Workbook that has 11 sheets so far,
I need to add another worksheet but the word "Worksheet" is dimmed under

the
"Insert" tab.
How can I add a new sheet?




Haddock

How can I add a worksheet when "Worksheet" is dimmed
 
YES!! thank you

"Bob Phillips" wrote:

Your workbook is probably protected, so unprotect it
(ToolsProtectionUnprotect Workbook...)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Haddock" wrote in message
...
In an Exel Workbook that has 11 sheets so far,
I need to add another worksheet but the word "Worksheet" is dimmed under

the
"Insert" tab.
How can I add a new sheet?






All times are GMT +1. The time now is 05:28 PM.

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