J
johnsail
Hi
I have a spreadsheet where I am trying to control where the user is able to
go and what he is able to do.
I am nearly there but would like to achieve two last things.
1 When code is being processed the cursor moves about in synch with the
code. Is there a way of stopping this?
2 I am happy for the user to delete lines as long as they are deleted one
line at a time - starting with the last line entered.
I do not want user to be able to delete a line or any part of a line if
there is data on the next line.
I have been trying to insert code eg if target.offset(1, 0).value <> "" then
etc etc but have been unable to work out where to put the code to prevent
user from deleting the value already in the target cell.
And I haven't discovered a VB command to 'undelete'.
Would appreciate some help here.
John
I have a spreadsheet where I am trying to control where the user is able to
go and what he is able to do.
I am nearly there but would like to achieve two last things.
1 When code is being processed the cursor moves about in synch with the
code. Is there a way of stopping this?
2 I am happy for the user to delete lines as long as they are deleted one
line at a time - starting with the last line entered.
I do not want user to be able to delete a line or any part of a line if
there is data on the next line.
I have been trying to insert code eg if target.offset(1, 0).value <> "" then
etc etc but have been unable to work out where to put the code to prevent
user from deleting the value already in the target cell.
And I haven't discovered a VB command to 'undelete'.
Would appreciate some help here.
John