ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   The worksheet option under "insert" is gray (unavailable)- why? (https://www.excelbanter.com/excel-worksheet-functions/106776-worksheet-option-under-insert-gray-unavailable-why.html)

Spreadsheet issues

The worksheet option under "insert" is gray (unavailable)- why?
 
I want to insert an additional worksheet and the worksheet option under
"insert" is gray. How can I get access to it in order to add a worksheet?

Gord Dibben

The worksheet option under "insert" is gray (unavailable)- why?
 
You must remove protection from the workbook.

ToolsProtectionUnProtect Workbook

You may have to supply a password.


Gord Dibben MS Excel MVP


On Wed, 23 Aug 2006 15:36:02 -0700, Spreadsheet issues <Spreadsheet
wrote:

I want to insert an additional worksheet and the worksheet option under
"insert" is gray. How can I get access to it in order to add a worksheet?




All times are GMT +1. The time now is 08:23 AM.

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