Hide work book while running user form & in case if another workbook opens, macro workbook should be hidden

[Maniraj280292]

Hi All,

I have prepared an userform to take inputs from users. The inputs are stored in the excel workbook. While using the userform, the workbook is hidden using VBA code.

The problem is when any another excel is opened during this time, the already hidden workbook is popping up.
This should not pop up even if some other excel workbook is opened.

Can anyone help me?

I am using MS excel 2007. I tried using "Ignore other applications" option. it is not working. It is not allowing the macro userform to run while opening the workbook.

Regards,
Maniraj

 

[mohan.pandey87]

Can you please share your file.

 

[Maniraj280292]

Hi, It is pretty big file to attach & also so many assoicated files which are all linked in the code.

When I launch the excel workbook, the userform gets activated and the workbook goes hidden. This works fine untill I open any other excel.

If i open any other excel, the hidden workbook pops up & if i minimize the workbook the userform also gets minimized with excel workbook.

Any idea? Below is the code currently i have used.

Private Sub UserForm_Activate()
Application.Visible = False

regards,
Maniraj