User form and hiding worksheets
 

I'm in the process of creating an App using Userforms, etc - using the
Workbook_Open to Bring up the Main Userform Menu -- the macro is also hiding
all other worksheets by name, except for the one worksheet (which is blank)
that can't be hidden, in the background. Is the kosher?
Or, is there more that I can do to give a more professional appearance?

User form and hiding worksheets
 

When the form loads, make the app non-visible.

application.Visible=false

and set it back to true when unloading.

--
HTH

Bob Phillips

"Jim May" wrote in message
news:vKFZe.121896$Ep.79127@lakeread02...
I'm in the process of creating an App using Userforms, etc - using the
Workbook_Open to Bring up the Main Userform Menu -- the macro is also
hiding
all other worksheets by name, except for the one worksheet (which is
blank)
that can't be hidden, in the background. Is the kosher?
Or, is there more that I can do to give a more professional appearance?

User form and hiding worksheets
 

Thanks Bob,
I didn't so much as know that there was an application.visible = false
option, until NOW!!
Tks again,
Jim

"Bob Phillips" wrote in message
...
When the form loads, make the app non-visible.

application.Visible=false

and set it back to true when unloading.

--
HTH

Bob Phillips

"Jim May" wrote in message
news:vKFZe.121896$Ep.79127@lakeread02...
I'm in the process of creating an App using Userforms, etc - using the
Workbook_Open to Bring up the Main Userform Menu -- the macro is also
hiding
all other worksheets by name, except for the one worksheet (which is
blank)
that can't be hidden, in the background. Is the kosher?
Or, is there more that I can do to give a more professional appearance?