| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sheet protection help
Pls adv why the Office 2000 SR-1 Small Business (Excel), can view the formula
created by Office XP Small Business eventhough it is protected by password? However, when i sent the file to another workstation that is using Office XP Small Business, it could only edit the cells that were unlocked by me but it couldn't view the formula as i used the Sheet Protection function. So, just curious why Office 2000 can view the formula (but it can't change the formula)? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sheet protection help
Hi
There are 2 attributes that can be set for the cell, that are invoked when Protection is applied. One is Locked and the other is Hidden. Dependant upon which was chosen would account for the differences you observe. You can (and perhaps normally) would select both. It is not a difference in behaviour between the two versions of Excel. -- Regards Roger Govier "wm" wrote in message ... Pls adv why the Office 2000 SR-1 Small Business (Excel), can view the formula created by Office XP Small Business eventhough it is protected by password? However, when i sent the file to another workstation that is using Office XP Small Business, it could only edit the cells that were unlocked by me but it couldn't view the formula as i used the Sheet Protection function. So, just curious why Office 2000 can view the formula (but it can't change the formula)? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sheet protection help
Hi Roger, thanks for your adv, it works.
"Roger Govier" wrote: Hi There are 2 attributes that can be set for the cell, that are invoked when Protection is applied. One is Locked and the other is Hidden. Dependant upon which was chosen would account for the differences you observe. You can (and perhaps normally) would select both. It is not a difference in behaviour between the two versions of Excel. -- Regards Roger Govier "wm" wrote in message ... Pls adv why the Office 2000 SR-1 Small Business (Excel), can view the formula created by Office XP Small Business eventhough it is protected by password? However, when i sent the file to another workstation that is using Office XP Small Business, it could only edit the cells that were unlocked by me but it couldn't view the formula as i used the Sheet Protection function. So, just curious why Office 2000 can view the formula (but it can't change the formula)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Named Ranges | Excel Worksheet Functions | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| Cell but not sheet protection | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
