Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you make a userform open automatically when you open excel? | Excel Worksheet Functions | |||
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
PC runs slow whenever workbook with UserForm is open | Excel Programming | |||
Open new workbook(s) when userform and excel are minimized | Excel Programming | |||
open Userform in Another workbook | Excel Programming |