G
Greg (codepug
I created a spreadsheet, and I used protection-->protect worksheet to
prevent users from deleting
the heading section that exists above the rows that follow. I also put
a password in. I want the user to be able to
insert or delete rows below the headings where they enter data, but
this is being prevented by Excel
since I set protect worksheet with a password.
If I set protect worksheet without using a password, it works great.
I coded 2-buttons for insert and delete
in hopes of getting around this problem. But the password pops up when
I hit a button attempting to insert
or delete. By the way, the heading section also contains calculated
cells that sum the columns. How do I protect the worksheet headings
area with password protection, and allow the user the ability to enter
data, and insert or delete rows below the headings
prevent users from deleting
the heading section that exists above the rows that follow. I also put
a password in. I want the user to be able to
insert or delete rows below the headings where they enter data, but
this is being prevented by Excel
since I set protect worksheet with a password.
If I set protect worksheet without using a password, it works great.
I coded 2-buttons for insert and delete
in hopes of getting around this problem. But the password pops up when
I hit a button attempting to insert
or delete. By the way, the heading section also contains calculated
cells that sum the columns. How do I protect the worksheet headings
area with password protection, and allow the user the ability to enter
data, and insert or delete rows below the headings