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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

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

On 31 May 2007 13:27:01 -0700, (E-Mail Removed) wrote:

>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