| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
If ActiveCell has a comment then exit sub
On Monday, January 12, 2015 at 7:57:01 PM UTC-8, GS wrote:
I see you commented out the protection code. You do know that VBA works on protected sheets when this parameter... UserInterfaceOnly = True ..is set, right? Note that this is non persistent between sessions and so protection must be reset (removed then replaced) at startup! -- Garry No, I did not know that. Have not heard of it. How would it be used in this code, perhaps like EnableEvents False/True at the beginning and end? Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's | Excel Programming | |||
| Amend sub to re-hide comment when activecell change to another | Excel Programming | |||
| Exit Field vs Exit Button...... | Excel Programming | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| If a called sub exit, how to the caller exit right away? | Excel Programming | |||
Threaded Mode
