Problem inserting a new worksheet

[Nick]

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

[Ron de Bruin]

Hi Nick

You have protect your workbook

Tools>Protection

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nick" <[email protected]> wrote in message news:[email protected]...
>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

[Nick]

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
>
> Tools>Protection
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Nick" <[email protected]> wrote in message news:[email protected]...
> >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
>
>
>

[Gord Dibben]

Nick

Ron is speaking of "workbook" protection, not "worksheet" protection.

Tools>Protection>Unprotect 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" <[email protected]>
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
>>
>> Tools>Protection
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Nick" <[email protected]> wrote in message news:[email protected]...
>> >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
>>
>>
>>

[Nick]

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.
>
> Tools>Protection>Unprotect 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" <[email protected]>
> 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
> >>
> >> Tools>Protection
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >> "Nick" <[email protected]> wrote in message news:[email protected]...
> >> >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
> >>
> >>
> >>
>
>