Can't use Excel whilst my userform is operational

[bralew]

Hi,

When I'm using multiple spreadsheet, my userform will not allow me to access other spreadsheets until my userform is closed. Whilst this isn't a major
problem it would ne nice to have this restriction removed. Is it possible?

Thanks All

[xlnitwit]

Is the form's ShowModal property set to True? If so, set it to False.

[frabulator]

This might be what you are looking for.

[bralew]

xlnitwit, Thanks, I'll check now.

[bralew]

Brilliant! Works wonderfully, Thank you xlnitwit