Hello to all,
you can create a macro that does this?
if I click DELETE in the range not yellow
to appear a msgbox "You can not cancel this cell"
I am attaching an example.
max_max
delete_canc.xls
Hello to all,
you can create a macro that does this?
if I click DELETE in the range not yellow
to appear a msgbox "You can not cancel this cell"
I am attaching an example.
max_max
delete_canc.xls
you can make every cell not yellow to locked and then add this code in worksheet change
however this method will not stop data being entered in locked cellsPlease Login or Register to view this content.
dont know if this is exactly what you want
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hello humdingaling,
you do not see the message:
MsgBox "You cannot cancel this cell"
The yellow range B4: H5 is not locked the rest of the sheet.
If you try to delete a different cell B4: H15 you do not see the message.
but the message to excel, "" the cell or chart you are trying ........ "
as the picture attached.
max_max
Appunti01.jpg
did you lock the sheet?
code just checks to see if cell is locked
you need it unlocked in order to work
Hello humdingaling,
the your macro works only in unprotected workbook.
This change to your macro editing cancels cells:
you can add more color changes as the cells, block the addition of columns or rows etc ...Please Login or Register to view this content.
max_max
Hello,
I changed the macro, I have now entered:
Please Login or Register to view this content.
because clicking CANC show the message to excel "The cell or chart you are editing...."?
you can not see this message?
max
had a look around
solution people just pointed to was to disable selection of protected cells
http://www.mrexcel.com/forum/excel-q...on-prompt.html
can that work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks