Date picker cell

One trick I have employed to prevent the user being able to edit the cell directly:
- insert an active-x Label
- position it over the cell
- make it the same size as the cell
- make it transparent
- make it move and resize with the cell

Then to amend the cell value
- attach a click event macro to the Label which triggers your date picker

Here is a carrot for donkey

Attached is simple example of blocking direct edit of a cell
- the cell is named Cell_1 using a named range
- avoids risk of rows or columns being inserted and changing the cell reference
- a message pops up when user clicks on cell
(in fact user is clicking on transparent label)
- the event macro moves\sizes the label in line with the cell
(I would not necessarily trigger it by every SelectionChange event - but the code is useful and the label must move when rows are inserted etc)

The protected cell in the attached workbook is cell D2

Please Login or Register  to view this content.