Method 'Range' of object '_Global' failed error message on running userform when another

Hi Kyle,

Just got it to work...
I used ThisWorkbook.Application.WindowState = xlMinimized in place of ActiveWindow.WindowState = xlMinimized in the code I provided above.

Thanks a lot for your time.

Best Regards
Sivakumar