View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alvin Hansen[_2_] Alvin Hansen[_2_] is offline
external usenet poster
 
Posts: 209
Default Starting userform

Thank's again Tom

Two things -- when I close the userform on X it dosn't close excel can I do
that?
Can i get in an make som changes and so on, you know like a backdor,
because know I can't get in to excel and make some more.

Best regards ALvin


"Tom Ogilvy" skrev:

Application.Visible = False

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Thank you all

But well can't i open the userform whitout all excel open you know like
hiding exel og minimize or something like that

Best regards alvin


"Pyball " skrev:

What Calligra sugests will work, but if you have another workbook open
whenever you change workbooks and activate the one with the userform
the userform will be shown.

If you want the userform to only be shown when the workbook is open the
first time put your code in the workbook_open event.

userform.show

Hope this helps.


---
Message posted from http://www.ExcelForum.com/