Freeze panes

[elgringo56]

I am trying, under macro control, to freeze and unfreeze the entire viewable area of the screen so that a message panal can appear while I move around in the sheet without the user seeing the movement. I cant figgure out how. Normal freeze pain requires the selected pointer cell be in the viewable area.

 

[Qroozn]

if you are trying to not show them what is happening why dont you do
application.screenupdating=false
at the beginning of the code

and

application.screenupdating=true
at the end of the code


this will stop the screen from moving, and speeds up the macro

 

[brettvba]

or just
application.screenupdating = false

at the start and it automaticaly updates at the end of the macro