Andy,
The short answer is no, you can't do this. The longer answer is
that yes, you could do this. Create a userform and put a calendar
control on that form. Then, use the BeforeRightClick event
procedure for that worksheet to display the form.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com