Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting first Unlocked Cell
I have the following macro in my workbook:
Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Application.WindowState < xlMaximized Then Application.WindowState = _ xlMaximized Range("A1:N1").Select ActiveWindow.View = xlPageBreakPreview ActiveWindow.Zoom = True Range("b8").Select End Sub What this does is 1) makes sure the app is maximized, as well as the "width" of the first page (A1:N1). 2) makes sure that the screen (which has is frozen at row 7) shows the first row under the frozen headers. But what I can't seem to get it to do is this: After I get my display right, I want the first Unlocked cell on the page to be the selection or activated cell. This is different on each worksheet. Suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tab to next unlocked cell | Excel Discussion (Misc queries) | |||
Moving from one unlocked cell to another | Excel Discussion (Misc queries) | |||
cannot tab to next unlocked cell | Excel Discussion (Misc queries) | |||
Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
hide contents of an unlocked cell | Excel Programming |