Hello Paul,
Please find attached report and is it possible to disable Delete option for
all possible ways on particular condition
Regards,
Chandrashekar B
On Tue, Jul 31, 2018 at 5:03 PM, Paul Schreiner
wrote:
> I'm not sure how you implemented the code.
> If it is installed properly, the
I'm not sure how you implemented the code.If it is installed properly, the user
cannot SELECT the entire row to delete!
The code goes in the "Thisworkbook" module.you can add the line:
Debug.Assert False
to have it pause to see if the macro is actually being called.
Hello Paul,
Thanks for the reply. I tried this code but if user delete entire row it
does not work.
My requirement is code should not allow to delete entire row but it should
allow to delete cells & it should allow to update cells/row.
Regards,
Chandru
On Mon, Jul 30, 2018 at 6:20 PM, Paul
I've done something like this before using a couple of different methods.
It's really going to depend on what you're trying to "block".
For instance, if you want to keep someone from deleting any of the rows 1-8,
thenyou can use a SelectionChange event to test for selected rows in the 1-8
range
Hello,
Is there any way to prevent from deletion based on condition but without
using protecting sheet.
For ex: Prevent user to delete row lesser than 8 but still he can able to
edit it.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
