Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Edit specific range in protected worksheet
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 fill series. How it can be possible. Thanks in advance Rao Ratan Singh |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Edit specific range in protected worksheet
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 "Rao Ratan Singh" wrote in message ... 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 fill series. How it can be possible. Thanks in advance Rao Ratan Singh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
allow users to edit a range in excel 2000 | Excel Discussion (Misc queries) | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Import/Export XML in protected worksheet | Excel Discussion (Misc queries) | |||
toggling which worksheet a named range refers to | Excel Discussion (Misc queries) |