View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sharad Sharad is offline
external usenet poster
 
Posts: 123
Default Running excel as an application


If you hide menus and toolbars, these will affect all other workbooks
the user opens.
Is this OK for you? If not, better leave it with hiding that workbook as
I told in earlier post.

In case that when the user runs this particular workbook, you think that
it is OK to hide menus and toolbars, there is a better way to hide
complete excel application itself.

Change the topmost earlier line which I told in workbook_open procedure
to:
Application.Visible = False

But in your userforms, DON'T FORGET the below line in Userform_Terminate
Procedure, in each of the userforms.

Application.Visible = True

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!