| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create Multiple passwords to edit multiple ranges?
I am using Excel 2003 and trying to create a spreadsheet that I can lock
entirely but allow certain users to make changes to certain cells by entering a password. I've tried the "Allow Users to Edit Ranges" option, but cannot get it to work. I've created the range and password, but when I lock the spreadsheet, the range of cells remain locked and I can't figure out how to unlock them with the preset password. The Excel Help files don't mention anything about this. Am I missing something? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table from multiple ranges? (Revisited) | Excel Discussion (Misc queries) | |||
| Multiple Ranges in 1 Column using VBA | Excel Discussion (Misc queries) | |||
| Pivot Table--How can I create from multiple sheets? | New Users to Excel | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Threaded Mode
