Hi Michael,

Either depress the left mouse button and select the
range, or type the required range in the names box
(above the A1 cell).


---
Regards,
Norman


wrote in message
ups.com...
I am using a Calendar Control on my spreadsheet to allow users to
select a date which is linked to a specfic cell. I used generic code
from Ron's website (http://www.rondebruin.nl/calendar.htm) to show and
use the calendar. However, I've run across a problem and was wondering
if anyone knows the answer.

I'm trying to copy the contents of my spreadsheet in order to paste
into a powerpoint deck. When I try to highlight a block of cells (by
dragging my mouse over them), and the cell linked to the calendar is
within the highlighted block, then the calendar automatically pops-up
and is included in the 'copy' I perform. Is there any way to keep that
from happening?

Thanks!
-Mike