Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tab to next unlocked cell ajimmitt Excel Discussion (Misc queries) 1 March 19th 10 01:39 AM
Moving from one unlocked cell to another Rich Excel Discussion (Misc queries) 3 March 23rd 09 02:39 PM
cannot tab to next unlocked cell iansmigger Excel Discussion (Misc queries) 0 March 13th 09 11:21 AM
Need to add cell comments in unlocked cell on protected worksheet dan400man Excel Discussion (Misc queries) 3 December 16th 05 08:02 PM
hide contents of an unlocked cell Tom Excel Programming 0 September 25th 03 08:39 AM


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"