| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading a calendar (user form) from another project (personal.xls)
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add calendar to VBA User Form | Excel Discussion (Misc queries) | |||
| Loading Add-ins to a Protected Project | Excel Programming | |||
| Auto loading of a user form sometimes | Excel Programming | |||
![Ollie[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
