I want to run some code when a particular cell is changed. This is my code:
Is there a problem with this code as I can't input data into certain cells in the worksheet?Please Login or Register to view this content.
I want to run some code when a particular cell is changed. This is my code:
Is there a problem with this code as I can't input data into certain cells in the worksheet?Please Login or Register to view this content.
Last edited by Aland2929; 05-05-2010 at 12:21 PM.
Are you sure they're not locked?I can't input data into certain cells in the worksheet
That code should not prevent entry in any cell.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
the worksheet-change event executes whenever anything is changed.
if your particular cell is for example B3 then the correct code would be
however, as sweep said, your code shouldn't lock your sheet in any way.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks