You could write VBA event code to re-selecting if those columns were selected.
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf Of Robert E. Carneal
Sent: 07 November 2011 18:31
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Freezing portions of sheet
*Please bear with me.
I can do the following:
1> Freeze the TOP portion of Excel by going to cell A8, and preserve Rows
one thru seven so as I advance down, the top seven rows are always visible.
2> Freeze the RIGHT portion of Excel by choosing a column, and thus
preserve two sides of the sheet.
3> Freeze TWO sides of the sheet buy choosing a cell such as D12. This
preserves the top 11 rows, and the leftmost three columns.
Ok, having said that, can I preserve THREE sides? For example, I am
endeavoring to preserve columns A, B, and C, and the top six rows, *plus*
columns H, I, and J. Thus, cells from D7 to G65536 would be navigable by
moving up and down. Cells to the right of "J" would be inaccessible. Is
that possible please?
**Thank you.
**Robert*
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar