Starting userform

P

Pyball

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
 
A

Alvin Hansen

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:
 
T

Tom Ogilvy

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:
Click to expand...
 
A

Alvin Hansen

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:
 
P

Pyball

To keep from being prompted to save the workbook before you exit use.

Application.DisplayAlerts = False
 
Top