| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events for a Protected Worksheet
I am trying to launch a simulated Conditional Formatting function (
have more than 3 scenerios) in code. It all works until I protect th worksheet...I have several cells that I want to disable the user fro selecting.. Is there a paticular event that can be used to work around this or is? I want to run the code in the "unlocked" cells while keep the users ou of other cells.... Cheers -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Events for a Protected Worksheet
In your event code you can unprotect the sheet, make your changes, reprotect
the sheet. -- Regards, Tom Ogilvy "jpendegraft " wrote in message ... I am trying to launch a simulated Conditional Formatting function (I have more than 3 scenerios) in code. It all works until I protect the worksheet...I have several cells that I want to disable the user from selecting.. Is there a paticular event that can be used to work around this or is? I want to run the code in the "unlocked" cells while keep the users out of other cells.... Cheers! --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Events for a Protected Worksheet
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
| IS THERE A WAY TO CLEAR WORKSHEET EVENTS USING ANOTHER MACRO | Excel Discussion (Misc queries) | |||
| Understand Workbook/Worksheet Events | Excel Discussion (Misc queries) | |||
| Worksheet Events | Excel Discussion (Misc queries) | |||
| Trapping Events generated by a Worksheet | Excel Programming | |||
![jpendegraft[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
