LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 293
Default Open UserForm From A Different Workbook

Greetings,

I have two workbooks,Workbook1 (The customer list) and Workbook2 (a
monthly data history, over a hundred and growing). At this time the
UserForm's and Module1's in each Workbook2 are all identical. The
opening code will load a Workbook1 automatically with each Workbook2
that I open.

Problem: Every time I update the code in any workvook2, I have to
export the RecordForm and/or the Moduke1, go into every workbook2's
code section and delete it's current RecordForm and/or Module1 and
then import the updated RecordForm and/or Module1. This is taking a
lot of time since there are a lot of updates (this is still a work in
progress).

Question: Is there any way to update all of Workbook2's
automatically? If not, is there a way to put the RecordForm (UserForm
and code) and Module1 in Workbook1 (which is always open if any
Workbook2 is open)? And if these are not possible, does anyone have
any suggestion as to where to look?

Any help is greatly appreciated.

-Minitman
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you make a userform open automatically when you open excel? Evan Excel Worksheet Functions 1 March 11th 10 02:24 AM
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. [email protected] Excel Programming 1 May 13th 07 01:46 PM
PC runs slow whenever workbook with UserForm is open dread Excel Programming 4 February 3rd 07 04:54 PM
Open new workbook(s) when userform and excel are minimized Arjan Excel Programming 5 November 9th 06 07:06 AM
open Userform in Another workbook geebee Excel Programming 5 October 4th 06 11:15 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"