View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B[_7_] Paul B[_7_] is offline
external usenet poster
 
Posts: 73
Default 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.