insert rows in protected sheet??

    Hi,, I have a worksheet, that has some rows/cells locked and others that are unlocked so users can enter data in these. I'd like to allow users to be able to insert rows only in the unlocked range. Is this possilbe? Thanks a lot!

    It depends partly on which version you (and they) have.


    In XP you can specify what the user can do, including inserting rows.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

    Depending on how they enter the data, you could designa UserForm, and then when they enter the data, it would trigger a macro which would unprotect the sheet, insert the row(s), and then re-protect the sheet.


    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt


    Old, slow, and confused - but at least I'm inconsistent!


    Rich
    (retired Excel 2003 user, 3.28.2008)

    ok,, that sounds easy, so i tried it and it seemed to be working,, but the next time i tried it, it asked for the password to unprotect. is there a way to unprotect it, insert rows, reprotect, using a macro and not have to give the user the password? Thanks!!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login