| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for worksheet change (add row) event (I think)
2003/2007
When I applied worksheet protection, I "permitted" the User to add rows to the sheet. What VBA can I use to remove protection from all cells in the newly added row so that the user may fill the cells with data, without permitting the User to change data in all the previously existing cells? I see two issues: (1) How do I "select" just the newly added cells within the UsedRange of the protected sheet? (2) Formatting those cells is not my concern as I know how to do that. TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Worksheet change event I think? | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
| worksheet change event | Excel Programming | |||
Threaded Mode
