Freeze panes using shortcut keys
Posted by RajaGopal on December 26, 2001 8:42 PM
How do i freeze panes using keyboard short cut keys .Please guide me
Posted by Jacob on December 26, 2001 8:59 PM
I'm not sure if there is a shortcut already set up to do this, but you can take a look in the Excel help contents under keyboard shortcuts.
We can however do this with vb.
Make a macro and addign it a shortcutkey
then in the module code put this
ActiveWindow.FreezePanes = True
This will freeze the panes whereever the current selected cell is whenever you activate the shortcut.
Hope this helps
Posted by RajaGopal on December 26, 2001 9:10 PM
Yea there is no shortcut defined already anyways will try ur option Jacob
Posted by More Beer!!! on December 26, 2001 10:10 PM
Macro works, but can't undo...
Jacobs macro will work, but I don't think you can "undo" it if you click in the wrong spot, or if you change your mind later. You can, however, create a button on your taskbar that will let you freeze the panes and then unfreeze them by clicking this button.
Here is how you create such a button:
1) Right click on the toolbar and then click customize
2) Click the Commands tab
3) Under Categories, click Window & Help
4) Click and Drag the Freeze Panes Icon onto your toolbar
5) Hit close and you're done...
Posted by Jim on December 27, 2001 5:37 AM
I just use alt-w-f
It's quick and I find it easier than fiddling with shortcut buttons and no VBA needed. It's also the same to unfreeze. But everyone has their favourite way I guess.