Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
hI
How do i get my userform to startup when the file opens. Alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
within the Workbook Activate add the below code
load userform userform.show --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
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 -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
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/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
Application.Quit
closes excel. -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... 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/ |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
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: Application.Quit closes excel. -- Regards, Tom Ogilvy "Alvin Hansen" wrote in message ... 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/ |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting userform
To keep from being prompted to save the workbook before you exit use.
Application.DisplayAlerts = False --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Starting with a zero? | Excel Discussion (Misc queries) | |||
Starting with command | Excel Programming | |||
Starting over | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
Starting a userform upon starting the file | Excel Programming |