Excel Sheet Always at Top

[bairamsunil]

Hello everyone,

I am using excel vba programming, in my application I always want to keep my first workbook.firstsheet active. I will be opening and closing some otherfiles in between the application.

While running the application i don't want to show all flikkering in my application, what all the files opened in the background, infact i need to show my main page always till the process is done.

I have tried :
Application.screenupdating = false
even then my focus goes off the main page.

Please help me in making this possible, as it is very urgent.

Thanks a lot
Bairam Sunil Kumar