software

Dear Sir/Mam,
I have a workbook with multiple worksheets. I protected a sheet but some
menu does not work when it is protectd. e.g. i want to go edit gt; fill gt;
series.

How it can be possible.

Thanks in advance

Rao Ratan Singh

If it's protected, you simply can't. You'd have to unprotect it first. Or
write a VBA procedure to unprotect, do the fill series, reprotect.
Bob Umlas
Excel MVP

quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Dear Sir/Mam,
gt; I have a workbook with multiple worksheets. I protected a sheet but some
gt; menu does not work when it is protectd. e.g. i want to go edit gt; fill gt;
gt; series.
gt;
gt; How it can be possible.
gt;
gt; Thanks in advance
gt;
gt; Rao Ratan Singh