$$Excel-Macros$$ Copy all userforms to another workbook

2009-12-11 Thread Mike Holder
I am currently working on an Excel project that I need to be able to update certain worksheets and userforms. I have built the code to replace the worksheets and have code to export / import an individual userform to the other workbook. I am having problems finding a way to loop through each of t

$$Excel-Macros$$ Copy all userforms to another workbook

2009-12-10 Thread Mike Holder
I am currently working on an Excel project that I need to be able to update certain worksheets and userforms. I have built the code to replace the worksheets and have code to export / import an individual userform to the other workbook. I am having problems finding a way to loop through each of t

$$Excel-Macros$$ Enable macros trouble with sharing

2009-05-28 Thread Mike Holder
I am using Excel 2007 and have built a workbook that uses a lot of VBA in the background. My problem centers around forcing the user to enable macros. Our security folks have set up rules on the use of macros which only allows the user to enable the macros. I researched the use a digital signa