UserForm Initialize open another workbook in background

**brajpalshishodia** · 04-21-2015, 02:00 PM

Hi Guys!!

Quick help would be highly appreciated as it is very urgent and created an embarrassing situation.

I created an User Form and add Exit button also to save and close the workbook and unload the User Form.

I tested it once and everything worked fine that User Form unloaded and Workbook closed after saving.e

Now when I open it again and User Form initialize, It open the another workbook in background "Solver.XLAM".Read Only.

I don't why but anything does not work as all the coding has been done on the basis of original workbook.

It is highly requested to look it quickly as the matter is very critical that I am not able to show anything to Client.

Workbook has been attached for your reference. Workbook name is "AdStock_Calcs_Template_060610_v6"

Regads,
Braj

**Norie** · 04-21-2015, 02:04 PM

You are calling a sub called CheckSolver in the Workbook_Open event.

That sub has this call and that might be where the problem lies, not the userform.

Please Login or Register  to view this content.

**brajpalshishodia** · 04-21-2015, 02:10 PM

Thanks a lot Norie.

In which words should I appraise your this prompt response.

Thanks a ton again.

You saved my face.

Best Regards,
Brajpal Shishodia