How do I format a cell, so the user must use a user calendar?
 

I created a user calendar by means of a macro. I want to set a cell in the
workbook so when someone clicks on the cell the calendar automatically comes
up so they can select a date.

How do I format a cell, so the user must use a user calendar?
 

nathan

See Ron de Bruin's site for code.

Adjust the range to suit

http://www.rondebruin.nl/calendar.htm


Gord Dibben MS Excel MVP

On Mon, 16 Jan 2006 09:25:03 -0800, nathan
wrote:

I created a user calendar by means of a macro. I want to set a cell in the
workbook so when someone clicks on the cell the calendar automatically comes
up so they can select a date.