Does a userform disable the spreadsheet it come from?

[dougchar001]

Newbie question but couldn't find the answer:

If I use a spreadsheet button to call a userform, does the spreadsheet, now in the background, become disabled from pressing other buttons or doing other things?

If so, can I change this and how? If not, oh well, is there a work-around?

Thanks much.

Doug

[Norie]

Doug

If a form is displayed modally you can't interact with Excel.

If you show the form modelessly you can interact.

To show modelessly, either,

Please Login or Register  to view this content.

or set the ShowModal propery of the form to False.

[dougchar001]

Thanks much. That did the trick. Cool.


Doug