Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: protection

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Re:protect sheet and protect workbook. I want to be able to have my sheet protected and still have the user be able to hide rows.
    Is this possible ?


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    when you protect the sheet select in the cheq boxes "format rows"
    and that ill do it

    [ This Message was edited by: brettvba on 2002-04-30 17:07 ]

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 16:54, cpc wrote:
    Re:protect sheet and protect workbook. I want to be able to have my sheet protected and still have the user be able to hide rows.
    Is this possible ?
    No ... cant' do!
    You might be able to do through a macro -- by unprotecting the sheet just before allowing the user to hide rows and the turning the sheet protection back on.

    Hope This Helps!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    select format rows in the cheq box? Where
    is that cheq box?

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 17:06, brettvba wrote:
    when you protect the sheet select in the cheq boxes "format rows"
    and that ill do it

    [ This Message was edited by: brettvba on 2002-04-30 17:07 ]
    Hi brettvba:
    I need some help understanding this one. I am using Windows 98 and Excel 97. When I go to protect the Worksheet, I do not have access to any check boxes that would allow me to format rows.

    Regards!

    Yogi Anand

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 17:06, brettvba wrote:
    when you protect the sheet select in the cheq boxes "format rows"
    and that ill do it

    [ This Message was edited by: brettvba on 2002-04-30 17:07 ]
    Brettvba: Select format rows cheq box, ? Where is that cheq box?

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    goto Tools,Protection,Protect Sheet
    Then the box pops up to enter a password etc
    and under the text
    "Allow all users of this worksheet to"
    Fifth cheqbox down is Format Rows

    although im not sure if this is a new feature in xp (thats the ver im using)
    so it may not be there not sure on that one.

  8. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 17:17, brettvba wrote:
    goto Tools,Protection,Protect Sheet
    Then the box pops up to enter a password etc
    and under the text
    "Allow all users of this worksheet to"
    Fifth cheqbox down is Format Rows

    although im not sure if this is a new feature in xp (thats the ver im using)
    so it may not be there not sure on that one.
    T H A N K S !

    Regards

    Yogi Anand

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    NO WORRIES YOGI

  10. #10
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-30 17:17, brettvba wrote:
    goto Tools,Protection,Protect Sheet
    Then the box pops up to enter a password etc
    and under the text
    "Allow all users of this worksheet to"
    Fifth cheqbox down is Format Rows

    although im not sure if this is a new feature in xp (thats the ver im using)
    so it may not be there not sure on that one.
    brettvba,

    Thanks alot.
    cpc

    [ This Message was edited by: cpc on 2002-04-30 18:27 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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