I dont want that message

Closed
Marlema - 30 Aug 2009 à 00:58
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 3 Sep 2009 à 02:50
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 response

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