Unlock the cells you want to allow editing/selection
make the control toolbox toolbar visible and click on the properties button.
Under the enable selection property, select unlocked cells
then go to Tools=Protect =Protect sheet.
Do this each time you open the workbook.
--
Regards,
Tom Ogilvy
"David Yowell" wrote in message
...
As I said in my original message, I do not have any experience at VB or
working with forms. Therefore, I am not familiar with codes. When you
say "unprotect all of the cells that I want to select and then put this
in the workbook code", what do you mean. Where is the "workbook code"?
Also, what does the following mean:
'*******change to your sheet name***********
With Worksheets("sheet1")
.Activate
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, UserInterfaceOnly:=True
End With
End Sub
Sorry for the stupid questions, but I'm afraid that I just do not
understand what you are talking about. Thanks for the help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!