How about unlocking cells up to column J, then protect the sheet and under 'Allow all users of this worksheet to:', untick the checkbox 'Select locked cells'?
I don't think you can freeze on three sides - I tried a combination of split and freeze panes but the one disables the other (xl2010).
--- In ExcelVBA@yahoogroups.com, bob.phillips@... wrote:
>
> 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