Results 1 to 10 of 11

Thread: Select Sheets For Specific Date By Clicking On A Calendar

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #7
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    14
    Even the instruction 'call' isn't necessary any more since 1997:

    Code:
    Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
        CalendarCellButton
    End Sub
    I made an alternative: see the attachment.
    Attached Files Attached Files
    Last edited by snb; 05-16-2013 at 02:56 PM.

Similar Threads

  1. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  2. Replies: 3
    Last Post: 06-10-2013, 06:12 PM
  3. Replies: 4
    Last Post: 06-10-2013, 01:27 PM
  4. Replies: 3
    Last Post: 05-17-2013, 01:22 PM
  5. Replies: 0
    Last Post: 02-27-2012, 01:07 AM

Posting Permissions

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