Results 1 to 5 of 5

copy&paste not avail if an event is running

Threaded View

  1. #1
    Registered User
    Join Date
    09-18-2003
    Posts
    39

    copy&paste not avail if an event is running

    Hello,
    I have a calendar that pops-up only when a specific range is selected,

    If I select a date, it works fine, but if select another cell that is out of the specific range (and without having selected a date in the calendar), I want it to close (visible = false). I then added the following line:
    If Application.Intersect(Target, Range("date")) Is Nothing Then
    Exit Sub
    Else
    Calendar1.Visible = False
    End If
    It works, but then it is no more possible to do copy&paste because when I select a different cell to paste, the macro runs and the copied cell is then lost (no more dashed blinking highlight)

    Any idea that could help?
    D
    Last edited by royUK; 04-16-2008 at 09:13 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1