Freeze panes

elgringo56 · Apr 16th, 2002, 06:16 PM

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 · Apr 16th, 2002, 06:26 PM

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 · Apr 16th, 2002, 06:27 PM

or just
application.screenupdating = false

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 06:16 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	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.

Apr 16th, 2002, 06:26 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	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

Apr 16th, 2002, 06:27 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	or just application.screenupdating = false at the start and it automaticaly updates at the end of the macro