| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete unprotected cells in protected worksheet
Trying to find a simple way to delete all the unprotected cells in a row of a
protected worksheet. I cannot use macros because of network security. I'm trying to make this simple for an inexperienced user. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Delete unprotected cells in protected worksheet
Hi,
Without a macro it's difficult but if the sheet is protected such that you cant select locked cells then hitting tab will move between unlocked cells. Mike "Len Silva" wrote: Trying to find a simple way to delete all the unprotected cells in a row of a protected worksheet. I cannot use macros because of network security. I'm trying to make this simple for an inexperienced user. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? | Excel Discussion (Misc queries) | |||
| Protected worksheet with unprotected cells i.c.w. remarks | Excel Worksheet Functions | |||
| adding comments to unprotected cell/range in protected worksheet | Excel Worksheet Functions | |||
| Move cursor through all unprotected cells in a protected worksheet | Excel Discussion (Misc queries) | |||
| Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
