Help with a calendar linking to cells

Campsalot · Apr 23rd, 2002, 08:26 AM

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 · Apr 23rd, 2002, 08:40 AM

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 · Apr 23rd, 2002, 03:35 PM

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

Apr 23rd, 2002, 08:40 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	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 __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 08:26 AM	#1
Campsalot New Member Join Date: Apr 2002 Location: A cold state with warm people Posts: 3	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?

Apr 23rd, 2002, 03:35 PM	#3
Campsalot New Member Join Date: Apr 2002 Location: A cold state with warm people Posts: 3	I will give it a shot. Thanks for the help.