MrExcel Publishing
Your One Stop for Excel Tips & Solutions

worksheet always on top


Posted by Marco R on July 08, 1999 7:15 AM

iv'e got a couple of workbooks but i wont one of those books to be on top .
so that other users can't see the actions that the main workbook does in the other workbooks.

(just like helpfiles do!!)

Please help, it can't be so hard..


Posted by Ivan Moala on July 08, 1999 9:21 AM

If you are accessing these other workbooks via
VBA macros and your routine always returns you
to the original wookbook then add the
following to your routine;
at the start
Application.Screenupdating = False
At the end of your routine add
Application.screenupdating = True
This will not update your screen until
you have completed the routine ie your screen
will not display any selected/activated objects
until the App.scr = True

Or you can hide the workbooks

eg workbooks(myworkbookname).Visible = False


Ivan