Trouttrap2
Well-known Member
- Joined
- May 11, 2010
- Messages
- 612
I inherited a workbook and it has this macro in 'Sheet1', not 'ThisWorkbook'. Can anyone tell me what it does? I'm thinking it grabs data from somewhere and populates 'Sheet1'
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Call ThisWorkbook.FillPriorPoll3650
End Sub
Oh, and when I use ALT+F8 the macro does not appear in the list for 'ThisWorkbook' or 'AllOpenWorkbooks'
Thank you everyone
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Call ThisWorkbook.FillPriorPoll3650
End Sub
Oh, and when I use ALT+F8 the macro does not appear in the list for 'ThisWorkbook' or 'AllOpenWorkbooks'
Thank you everyone