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.
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.
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.
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.
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.