Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Location
    England
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lock worksheets (Excel 2003)

    I know that I can lock and compare workbooks side by side, but is it possible to lock and compare (scroll) 2 worksheets from the same worksheet?

    Thanks, Tigers

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Lock worksheets (Excel 2003)

    I have not tried this in 2003 yet, so see if it will work.

    First we need to duplicate the window. With your workbook open, choose Window : New Window
    Then either choose Window : Compare Side by Side, or choose Window : Arrange : Vertical/Horozontal, then Compare.

    This is untested as I do not have 2003 on hand!
    Try it out and post back if it did not work.
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lock worksheets (Excel 2003)

    Select Window | New Window to open a second window on the active workbook. Activate one of the worksheets you want to compare in the original window, and the other one in the new window. You can now select Window | Compare Side By Side With.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Lock worksheets (Excel 2003)

    Hi Tigers,

    It can be done...
    Here is a web page with the steps...
    Compare Sheets
    Regards,
    Rudi

  5. #5
    New Lounger
    Join Date
    Jan 2005
    Location
    England
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lock worksheets (Excel 2003)

    Hi Guys,

    Thanks for the responses, just what I needed.
    Wonderful website with brilliant members! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    Tigers

Posting Permissions

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