| 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) | |||
Linear Mode
