Minimise form. leave open in background etc.

  • Thread starter Thread starter RITCHI
  • Start date Start date
R

RITCHI

Hi

I have a user form which has been set up to be used as a menu with lots
of buttons doing various operations.
After clicking a button and carrying out the task(s) I would like to
able to move back into a worksheet(s) do some work and then step back
to the form.

At present I have to close the form do the work and then reopen it.

Is it possible to minimise the form, leave it open in the background
whilst I work on the sheets and then maximise to choose/use further
menu items etc.?

Any help with coding would be gratefully received.


Thanks

Richi
 
Richi,

You can make the userform modeless. In the properties for the form, set
ShowModal property to False. I think this started with Excel 2000.
 

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

Similar Threads

Menu minimises forms 3
games minimising to desktop 3
Windows 7 Why do pages etc auto minimise? 14
Setting windows of applications to open minimised 2
Access how to open existing database from another database using Access - VBA 0
Minimise Access Window 2
Minimising and restoring a popup form with code 1
Opening form unexpectedly closes other form 0

Back
Top