Fix userform position and make it non-selectable? 1

[knifey]

Hi,
I have a progressbar on a userform which updates on each iteration of my loop.
My problem is that when my code is running and I attempt to move the progressbar window it leaves a trail on the screen (where the window was on the previous iteration).
Is there a way to stop the screen trails? Or if not, is there a way to fix the position of the userform on the screen so as it cannot be moved or selected by the user?
Any help or advice will be much appreciated.
Knifey

 

[combo]

Your code is running when Application.ScreenUpdating is set to 'False'. Try either set it to 'True' (it can slow down the code if you work with cells) or use another way to inform user about the progress status (Application.StatusBar for instance).

combo

 

[knifey]

Thanks combo, Your a star!
Knifey

 

[combo]

Thanks!

combo