Starting userform

  • Thread starter Thread starter Guest
  • Start date Start date
within the Workbook Activate add the below code

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

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

userform.show

Hope this helps
 
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.Quit

closes excel.

--
Regards,
Tom Ogilvy

Alvin Hansen said:
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:
 
Many many thanks again Tom
Now its working
But now i can't get in to excel and make some changes
i ges i shall whait with
Application.Visible = False
Application.Quit
To i'm Finish yes???

Second when i close excel it ask me about saving the file
can't i close excel whitout excel asking about saving the file.

But again many thanks to you

Regards alvin





"Tom Ogilvy" skrev:
 
To keep from being prompted to save the workbook before you exit use.

Application.DisplayAlerts = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top