I dont want that message

Closed
Marlema - Aug 30, 2009 at 12:58 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 3, 2009 at 02:50 AM
Hello,

I have a column of a Excel sheet that need to be filled with dates supplied by the user. Once the date is entered in the cell, it can´t be changed by the user in any way. Date should remains in that cell even if it is entered wrong, (Example: entering 10-04-2009 intead of 16-08-2007).

The Sheet uses the Worksheet_BeforeDoubleClick scheme since by double clicking on any cell of that column, it will perform just one of two acctions:

1) If there is a date on the clicked cell, it will show you some information stored in another Sheet.

or

2) If the clicked cell is empty, it will just allow you to enter a date in the cell.

Everything works fine in my Macro except when 2) occurs. It allows me to enter the date and it remains there, but then display me a message saying that the cell is protected.

I don´t want that message shown since it is meaningless.

Could anyone help me out with this... please?. Thanks.

Marlema
marlema1964@hotmail.com

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 3, 2009 at 02:50 AM
remove the code for the condition 2 from the macro
or put a condition that if the cell is blank, do nothing
0