Results 1 to 2 of 2

Thread: Lock a colum after one pane had been freezed

  1. #1
    Junior Member
    Join Date
    Aug 2012
    Posts
    1
    Rep Power
    0

    Lock a colum after one pane had been freezed

    hello guys,
    i wonder how can we lock one entire colum example B and etc after A colum had been freezed-panes?i hope it can make it easier to me when i opened the file, it is straightly appear the colum that had been locked to the following freeze-panes colum.please help.thanks.example file is below:

    freezepanes.xlsx

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Welcome to ExcelFox community.

    Can you be a little more clear as to what exactly you are trying to achieve. Not able to understand what it is based on what you've shared.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Lock Cells After Data Entered
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 06-28-2013, 10:52 PM
  2. Excel 2007 - Freeze Pane without lines
    By irshath in forum Excel Help
    Replies: 1
    Last Post: 02-23-2013, 11:27 PM
  3. Replies: 3
    Last Post: 12-05-2012, 09:51 PM
  4. Scroll Lock and Unlock using VBA
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 11-08-2011, 08:59 AM
  5. Lock cells on the basis of date VBA
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 22
    Last Post: 09-27-2011, 03:56 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •