Non-VBA calendar popup/control?

  • Thread starter Thread starter Lostguy
  • Start date Start date
L

Lostguy

Hello!
I send my workbook out to many users and I am always looking for ways
to improve it.

For date entries in cells, I use data validation to make sure the
dates are legit, but is there any way to have one of those calendars
that pops up when you select a cell, allows entry of the picked date
to that cell, and then closes the popup?

This is for Excel 2003 and it has to be non-VBA because many of the
users are scared of the macro warning that pops up when you open a VBA
workbook.

Thanks for any help!

V/R

Lost
 
If this cannot be done without using VBA then you could get a code signing
certificate. Once the client has trusted you and installed the certificate the
Macro popup will not be displayed. It is a bit of a learning curve but I sign
code simply to get rid of this popup every time I open the workbook.
 
Back
Top