Macro to open range of hyperlinks

[mattmc419]

Hey Guys,

Is the following possible:

In Column A is a list of dates.

Column F is filled with hyperlinks.

Data for both Columns starts in Row 10.

I want to create a macro that, when a Button is clicked, two Prompt boxes come up. First, one asking for a start date, and then the second asking for an end date (mm/dd/yyyy).

Once those two dates are entered, I'd like the hyperlinks (Col F) matching any of those dates (Col A) to automatically open.

Thanks!
Matt

[ragulduy]

Something along the lines of:

Please Login or Register  to view this content.

[mattmc419]

hmm, that looks simple enough, but no matter what I input to it, none of the hyperlinks open.