Did you somehow turn off Events?
Type and Enter the following in the Immediate VBE Window. (Ctrl-G opens that window in VBE)
Code:
Application.EnableEvents = True
Hello again Datasmart,
Some more queries:
1. Where do I stick that piece of syntax when I do a CTRL 'G'
Is it in 'Reference' ?
2. Also, to cut the long story short, what can i do to the code that you've given me to make the button 'GREYED OUT' as opposed to it disappearing ?! Remember, i'm using a 'FORM' button.
3. One more thing - can the 'event' code work in respect to the position of the cursor on the worksheet, e.g
Position of the button in on B1
IF the cursor is on ROW1 - button should be disabled & if the cursor below A1 (ROW2,ROW3,ROW4, etc...) the cursor should be ENABLED.
In short, button should ONLY be DISABLED when the CURSOR is anywhere on ROW1.
Thanks - DC