Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent value being deleted
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent value being deleted
I don't know the answer to 2nd half of your quesiton, but for first part, you
can use: Application.ScreenUpdating = False 'and it's counterpart Application.ScreenUpdating = True -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "johnsail" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent an image from being deleted or replaced | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
If No is deleted in middle of sequence,Nos alter after deleted No | New Users to Excel | |||
Solution Required to prevent #Ref! when rows deleted | Excel Worksheet Functions | |||
How do i prevent a formula in excel from being deleted? | Excel Discussion (Misc queries) |