Hi there, In Excel 2000, I have a protected sheet (with password) that I would like to be able to click a button and have it unprotect the sheet, unhide the next availalbe row and rehide the rest, then reprotect the sheet again. (there are 60 rows set up for names and calculations, however we only show 30 rows and just unhide additional rows as needed.) We would like the user to NOT have to unprotect the sheet to do this because they usually forget to reprotect it and mess with the calculations. Is there some simple code that will help me do this? I am not quite sure how to have VBA determine what is the next available row.
Thanks,
Dawn
Thanks,
Dawn