Worksheet Protection
 

Hello all. I am new to programming for Excel and I have a question
concerning worksheet protection.

I want to Protect my worksheets within a workbook, yet I want certain
cells to be edited by the user and for my command buttons to work
properly. How can I accomplish this? Is it best to have named ranges
for the cells to edited? And is there anything specfic for text boxes
and command buttons?

Thanks,
Julia

With the sheet unprotected, select any cells which you want the user to be
able to enter data into. Click on Format;Cells;Protection and uncheck the
Locked box. Now when you protect the sheet, those cells will be available
for data entry. Command buttons still work, and you can enter into Text
Boxes if you format the text box so it's not locked. (format text box;
protection)

" wrote:

Hello all. I am new to programming for Excel and I have a question
concerning worksheet protection.

I want to Protect my worksheets within a workbook, yet I want certain
cells to be edited by the user and for my command buttons to work
properly. How can I accomplish this? Is it best to have named ranges
for the cells to edited? And is there anything specfic for text boxes
and command buttons?

Thanks,
Julia

Thanks for the prompt response.

Is it possible to protection the formulas and data in a pivot table without
locking the pivot table selections?

"PegL" wrote:

With the sheet unprotected, select any cells which you want the user to be
able to enter data into. Click on Format;Cells;Protection and uncheck the
Locked box. Now when you protect the sheet, those cells will be available
for data entry. Command buttons still work, and you can enter into Text
Boxes if you format the text box so it's not locked. (format text box;
protection)

" wrote:

Hello all. I am new to programming for Excel and I have a question
concerning worksheet protection.

I want to Protect my worksheets within a workbook, yet I want certain
cells to be edited by the user and for my command buttons to work
properly. How can I accomplish this? Is it best to have named ranges
for the cells to edited? And is there anything specfic for text boxes
and command buttons?

Thanks,
Julia