View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Formatting Cells

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!