View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default Loading a calendar (user form) from another project (personal.xls)

Ollie, try putting personal.xls! in front of your macro, so if you are
calling MyCal use personal.xls!MyCal

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ollie" wrote in message
oups.com...
I am very new to this, visual basic programming in Excel I mean, and I
seem to have got stuck on the first hurdle!
I am trying to open a calendar (which is located on a userform in the
Personal.xls project) by pressing a button on the worksheet in another
project.
I can open any userform WITHIN my other project but not the calendar so
it is obviously a matter of accessing it with some further code.
Can anyone help me out of my misery?