Formatting Cells
dyowell, you could use something like this, unprotect the cells you want to
select
then put this in the thisworkbook code
Private Sub Workbook_Open()
'will not let you select locked cells
'This is a setting that Excel does not remember between closings, so this
'will run each time you open the workbook
'*******change to your sheet name***********
With Worksheets("sheet1")
.Activate
.EnableSelection = xlUnlockedCells
.Protect Contents:=True, UserInterfaceOnly:=True
End With
End Sub
--
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 **
"dyowell" wrote in message
...
I have designed a worksheet that I want to use for
quotes. I am able to print out the worksheet and it looks
just fine. However, I would like to format the worksheet
so that every cell that is not used in the worksheet can
not even be "clicked". In other words, I would like to
make those unused cells part of the background.
I have not designed this sheet in form view because I am
not familiar with that.
If anyone has any ideas how to do this, please let me
know. Thanks in advance.
|