Calendar Control & Copy

[michael.haight]

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

 

[Norman Jones]

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).

 

[Gord Dibben]

The calendar will pop-up if you just select the cell and release producing a
full click.

Try clicking on a cell but don't release until after you drag across your range.

Or disable events prior to the selecting.

Sub enable_events()
Application.EnableEvents = False
End Sub


Gord Dibben MS Excel MVP