Results 1 to 3 of 3
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Redcliff, Alberta, Canada
    Thanked 5 Times in 5 Posts

    Re: Limited protection (97-SR2)

    You have two choices - write a macro that unprotects the sheet for formatting (perhaps including autofit instructions within the macro) and then protects the sheet again.
    Or use your god-like powers as designer of the sheet and format your columns extra wide.

    I know which one is easier...

    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    San Jose, California, USA
    Thanked 0 Times in 0 Posts

    Re: Limited protection (97-SR2)

    To answer your last question about defining a few ranges and protecting those. Yes, you can do that, I've done that when regular protection was too restrictive (plus some features do not work on a protected sheet). You'd define the range then in the worksheet's change() event you can determine if the active cell is within the "protected" zone (your defined ranges). If it is, then warn the user and issue the undo command to restore the previous data.

    You'd need the .Intersect method of Range and the Application.Undo

    Deb <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Thanked 0 Times in 0 Posts

    Limited protection (97-SR2)

    My workbook has 20+ sheets all linked to a MASTER sheet.

    In the non-master sheets:
    I need to protect 2 columns and 1 row on a sheet that has 12 columns.
    This is easy to do.

    Problem is, my users will enter data in the adjacent cells and will need to expand those columns for printing or viewing the contents of these 'collapsed' strings.
    When a sheet is protected, there is no 'stretching' allowed.
    I've tried all of the alternatives available under protection. (Contents, Objects, Scenarios)

    Since all sheets are identical, couldn't I just define a range or two, and make a global call to not allow any changes?
    How might this be implemented?

    Here's a Word doc that has all of the info I'm shooting for.
    Hope this, you help me. <img src=/S/hello.gif border=0 alt=hello width=25 height=29>
    Attached Files Attached Files

Posting Permissions

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