Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to center Selected Cell in Current Window
2003/2007
What VBA code can I use to center the selected cell in the current window? Programmatically, I have selected a cell and that cell is in the current window for the 500+ sheets in a workbook. BTW, the code below is from Automation of Excel from Access. Therefore, the standard Excel objects Application, ActiveSheet, Acvtiveworkbook are oSht, oWbk1 & oXL respectively. The code I used is next: For Each oSht In oWbk1.Worksheets oSht.Activate oXL.ActiveWindow.View = xlNormalView oXL.ActiveWindow.Zoom = 75 oSht.Columns.AutoFit oSht.ActiveCell.Select oSht.Protect _ DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ AllowSorting:=True, _ AllowFiltering:=True, _ AllowUsingPivotTables:=True Next oSht I would like to have that selected cell be in the middle of that screen no matter how many rows there are in the worksheet. TIA EagleOne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Center Comment Over Selected Cell | Excel Programming | |||
Macro to run relative to current selected cell | Excel Discussion (Misc queries) | |||
ctrl-v paste a window shot rather than the selected text/cell | Excel Worksheet Functions | |||
a way to color the CURRENT row or cell when selected | Excel Programming | |||
how can one obtain the current selected cell value | Excel Programming |