| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem inserting a new worksheet
I cannot insert additional worksheets into the exisiting book. The option is
faded out, suggesting I might have something locked or otherwise. Can you help please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem inserting a new worksheet
Hi Nick
You have protect your workbook ToolsProtection -- Regards Ron de Bruin http://www.rondebruin.nl "Nick" wrote in message ... I cannot insert additional worksheets into the exisiting book. The option is faded out, suggesting I might have something locked or otherwise. Can you help please |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem inserting a new worksheet
Hi Ron, I have several pages in the document and I have made sure that they
all unprotected, but they "insert" option remains greyed out "Ron de Bruin" wrote: Hi Nick You have protect your workbook ToolsProtection -- Regards Ron de Bruin http://www.rondebruin.nl "Nick" wrote in message ... I cannot insert additional worksheets into the exisiting book. The option is faded out, suggesting I might have something locked or otherwise. Can you help please |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem inserting a new worksheet
Nick
Ron is speaking of "workbook" protection, not "worksheet" protection. ToolsProtectionUnprotect Workbook. Sheet protection just prevents changes to the sheet which is protected. Workbook protection prevents changes to the workbook, like adding or deleting a sheet. Gord Dibben Excel MVP On Wed, 16 Nov 2005 09:42:09 -0800, "Nick" wrote: Hi Ron, I have several pages in the document and I have made sure that they all unprotected, but they "insert" option remains greyed out "Ron de Bruin" wrote: Hi Nick You have protect your workbook ToolsProtection -- Regards Ron de Bruin http://www.rondebruin.nl "Nick" wrote in message ... I cannot insert additional worksheets into the exisiting book. The option is faded out, suggesting I might have something locked or otherwise. Can you help please |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem inserting a new worksheet
Brilliant, thanks very much all sorted and apologies to Ron for not reading
his help properly Nick "Gord Dibben" wrote: Nick Ron is speaking of "workbook" protection, not "worksheet" protection. ToolsProtectionUnprotect Workbook. Sheet protection just prevents changes to the sheet which is protected. Workbook protection prevents changes to the workbook, like adding or deleting a sheet. Gord Dibben Excel MVP On Wed, 16 Nov 2005 09:42:09 -0800, "Nick" wrote: Hi Ron, I have several pages in the document and I have made sure that they all unprotected, but they "insert" option remains greyed out "Ron de Bruin" wrote: Hi Nick You have protect your workbook ToolsProtection -- Regards Ron de Bruin http://www.rondebruin.nl "Nick" wrote in message ... I cannot insert additional worksheets into the exisiting book. The option is faded out, suggesting I might have something locked or otherwise. Can you help please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Problem w/ inserting rows | Excel Discussion (Misc queries) | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| Updating database worksheet problem (Template Wizard) | Excel Discussion (Misc queries) | |||
Linear Mode
