Hello,

I'm creating a user form and I was trying some code to have the userform
showed off only, without the workbook and Excel showing off.

It works great , too great since I can't unhide anymore. I tried ALT+F11 or
F7 and nothing worked.

When I open the Excel file, I see my sheets, and my msg box appears and when
I click OK on the MSG BOX, the whole workbook and Excel disappears and my
user form appears.

I'm relatively new to VBA.

Thanks a lot in advance for any help.

Regards

Stephan

Can you open it without enabling the macros, make the change and save with
another name?
--
HTH,
Barb Reinhardt




"Stephan Leduc" wrote:

> Hello,
>
> I'm creating a user form and I was trying some code to have the userform
> showed off only, without the workbook and Excel showing off.
>
> It works great , too great since I can't unhide anymore. I tried ALT+F11 or
> F7 and nothing worked.
>
> When I open the Excel file, I see my sheets, and my msg box appears and when
> I click OK on the MSG BOX, the whole workbook and Excel disappears and my
> user form appears.
>
> I'm relatively new to VBA.
>
> Thanks a lot in advance for any help.
>
> Regards
>
> Stephan
>
>

Close excel
Open excel.
Toggle the security settings to not allow macros to run.
Open your workbook.
Modify your code so that it doesn't do the hiding.
save your workbook.
Close that workbook
change your settings to what you like
reopen your workbook.

=======
You should be able to open your workbook while depressing the shift key and the
auto_open and workbook_open procedures won't run. Macros will still be enabled,
but those two events won't be automatic.

Stephan Leduc wrote:
>
> Hello,
>
> I'm creating a user form and I was trying some code to have the userform
> showed off only, without the workbook and Excel showing off.
>
> It works great , too great since I can't unhide anymore. I tried ALT+F11 or
> F7 and nothing worked.
>
> When I open the Excel file, I see my sheets, and my msg box appears and when
> I click OK on the MSG BOX, the whole workbook and Excel disappears and my
> user form appears.
>
> I'm relatively new to VBA.
>
> Thanks a lot in advance for any help.
>
> Regards
>
> Stephan

--

Dave Peterson

Thanks Dave,

It does work. You are fantastic.

Regards

Stephan

"Dave Peterson" wrote:

> Close excel
> Open excel.
> Toggle the security settings to not allow macros to run.
> Open your workbook.
> Modify your code so that it doesn't do the hiding.
> save your workbook.
> Close that workbook
> change your settings to what you like
> reopen your workbook.
>
> =======
> You should be able to open your workbook while depressing the shift key and the
> auto_open and workbook_open procedures won't run. Macros will still be enabled,
> but those two events won't be automatic.
>
> Stephan Leduc wrote:
> >
> > Hello,
> >
> > I'm creating a user form and I was trying some code to have the userform
> > showed off only, without the workbook and Excel showing off.
> >
> > It works great , too great since I can't unhide anymore. I tried ALT+F11 or
> > F7 and nothing worked.
> >
> > When I open the Excel file, I see my sheets, and my msg box appears and when
> > I click OK on the MSG BOX, the whole workbook and Excel disappears and my
> > user form appears.
> >
> > I'm relatively new to VBA.
> >
> > Thanks a lot in advance for any help.
> >
> > Regards
> >
> > Stephan
>
> --
>
> Dave Peterson
>