Protection options through VBA

R

Richard

I currently am using:

Worksheets(Index).EnableSelection = xlUnlockedCells
Worksheets(Index).Protect

to protect my worksheets after unprotecting them for some changes. But one of the sheets needs to
allow the user to adjust the charts to suit their needs and another needs to allow the selection of
both locked and unlocked cells. I looked throughout the VB help but found no list of these constants.

What properties would give me these benefits?

Thanks,

Richard
 
S

Simon Lloyd

Hi im new to excel programming but i have just created a workbook tha
has different parts of different sheets locked, i used a simple butto
to the tool bar which i attatched the unprotect command out of tools,
also included in the macro the facility that when you change views o
worksheets the sheet locks again.

hope it helps somehow!

Simo
 
Top