Hyperlink a calender

[Vitor Ruivo]

Hi everyone.

I have a excel workbook for daily information (from Day 1 to day 31), what I`m trying to do is hyperlink all the 31 spread sheets in to a calendar.
I can do it with individual hyperlinks directly on a cell or a shape, but it`s not what I want.
What I would like to do is, introduce a calendar on a Main spread Sheet and on each day of the calendar (ex. Day 1) press it and redirect me directly to the spread sheet of Day 1.
Is it possible, if yes how?

Could you help me?

Vitor

[mickgibbons1]

yes this is possible

try recording a macro or try this code: So here in the case path i will write a code for, just change it C:Users\Word\Documents\Sheet2.xlsx, so the command would be:

sub Openfile()
Workbooks.open ("C:\Users\Work\Documents\Sheet2.xlsx")
End Sub

[Vitor Ruivo]

Thanks, but I`m not a programmer
Need more help on this case, thanks