+ Reply to Thread
Results 1 to 2 of 2

VBA code has disabled my paste option

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    VBA code has disabled my paste option

    I have a VBA code that enables a pop-up calendar for a couple of cells but it seems that it has disabled my paste function completely. I need it back. Please help. Here is the code I have:

    Private Sub Calendar1_Click()
    ActiveCell.Value = Calendar1.Value
    End Sub

    Private Sub Calendar2_Click()
    ActiveCell.Value = Calendar2.Value
    End Sub

    Private Sub Calendar3_Click()
    ActiveCell.Value = Calendar3.Value
    End Sub

    Private Sub Calendar4_Click()
    ActiveCell.Value = Calendar4.Value
    End Sub

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If ActiveCell.Address = "$K$2" Then
    Calendar1.Visible = True
    Else
    Calendar1.Visible = False
    End If
    If ActiveCell.Address = "$C$8" Then
    Calendar2.Visible = True
    Else
    Calendar2.Visible = False
    End If
    If ActiveCell.Address = "$I$8" Then
    Calendar3.Visible = True
    Else
    Calendar3.Visible = False
    End If
    If ActiveCell.Address = "$A$4" Then
    Calendar4.Visible = True
    Else
    Calendar4.Visible = False
    End If
    End Sub

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: VBA code has disabled my paste option

    Are you sure its your code?
    Do you use Skype??
    Gary's Student

+ Reply to Thread

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