Re: $$Excel-Macros$$ How to open up a user form in workbook1 from workbook2?

2014-02-08 Thread Darius Dempsey
Oh by the way, what I was hoping is that when they choose a workbook from the menu (form) the workbook would open and the menu(form) would disappear, until the user wants to go back to the menu, then they would click on a button on the worksheet that will reopen the Menu(form). Now if that cant be

Re: $$Excel-Macros$$ How to open up a user form in workbook1 from workbook2?

2014-02-08 Thread Darius Dempsey
Yes,I will send it in a minute..Thanks.. On Fri, Feb 7, 2014 at 8:47 PM, Ricardo(R) wrote: > Hi pls. you can share your file example ? > > > 2014-02-07 15:20 GMT-02:00 Darius Dempsey : > >> Basically I would like for the user to be able to click on button on >> worksheet to open up the User Men

Re: $$Excel-Macros$$ How to open up a user form in workbook1 from workbook2?

2014-02-08 Thread Darius Dempsey
the workbook in which the menu form exist is simply for the menu and forms.. all the other workbooks exist seperately. These workbooks have been used by the company for years, and it would be too much work to try to combine them all into one workbook in order to make it more simple for coding. So t

Re: $$Excel-Macros$$ How to open up a user form in workbook1 from workbook2?

2014-02-07 Thread ashish koul
Can you please tell us what is the use of userform also will that workbook will be always open in which you have designed the userform.? On Sat, Feb 8, 2014 at 7:17 AM, Ricardo(R) wrote: > Hi pls. you can share your file example ? > > > 2014-02-07 15:20 GMT-02:00 Darius Dempsey : > > Basical

Re: $$Excel-Macros$$ How to open up a user form in workbook1 from workbook2?

2014-02-07 Thread Ricardo®
Hi pls. you can share your file example ? 2014-02-07 15:20 GMT-02:00 Darius Dempsey : > Basically I would like for the user to be able to click on button on > worksheet to open up the User Menu forn that exist in another workbook. I > have a user Menu i created that the user uses to navigate to

$$Excel-Macros$$ How to open up a user form in workbook1 from workbook2?

2014-02-07 Thread Darius Dempsey
Basically I would like for the user to be able to click on button on worksheet to open up the User Menu forn that exist in another workbook. I have a user Menu i created that the user uses to navigate to and open up certain workbooks and then the user form automatically disappears while they a