David,
To put in this macro, from your workbook right-click the workbook's icon and
pick View Code. This icon is to the left of the "File" menu this will open
the VBA editor, in the left hand window double click on thisworkbook, under
your workbook name, and paste the code in the window that opens on the right
hand side, press Alt and Q to close this window and go back to your
workbook, now this will run every time you open the workbook. If you are
using excel 2000 or newer you may have to change the macro security
settings to get the macro to run.
'*******change to your sheet name***********
With Worksheets("sheet1")
Change sheet1 to the name of the worksheet tab name of the sheet you are
using.
"unprotect all of the cells that I want to select "
Select the cells you want to enter data in, select the first one and hold
down the Ctrl key and click on the others, then format, cells, protection,
and uncheck locked, OK. Save the workbook, close it and then open it again,
you should then only be able to select the cells that you unlocked
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
"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!