Help with a calendar linking to cells

[Campsalot]

Is there any type of macro or method I can use to get a spreadsheet to link to the computers calendar and automatically go direcly to the cell that equals that week?

 

[gareth]

I've got just the code for you

Sub OpenCalendar()
' Displays the UserForm and calendar
' Shortcuts should be made to this procedure
frmCalendar.Show
End Sub.

It worked for me,hope it will work for you

 

[Campsalot]

I will give it a shot. Thanks for the help.