| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet change
I have the following code to protect cells in a shared workbook. What I'm
trying to do is tun off the undo if the cell is blank Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Application.EnableEvents = False Application.Undo Application.EnableEvents = True Application.Speech.Speak "Locked Cell" End If End Sub Thanks for any help. Thanks for all the help today |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change the pivot chart automaticaly as values in the worksheet change | Excel Worksheet Functions | |||
| change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
| Change to Worksheet Change Event | Excel Programming | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Threaded Mode
