Simple Questions

C

cgi_pro

Hello

1- How do I make my spreadsheet have its grids non-visible?

2- How do I make (at the same time) a certain cell write protected as
well as if someone clicks on it then its border does not get focus
(meaning: you know when you click on a cell, then its border lines
weight get larger as to tell you that this is the cell that you have
chosen, but I don't want this focus feature, I want it to look like as
if it is a webpage, and you know when you glick on any work on a
webpage it doesn't get any focus)?
 
V

Vitalie Ciobanu

1. tools/options under view uncheck gridlines

2. i think you can not turn off this focus feature, maybe guys who know
vba/excel better than me can solve this issue
 
D

Debra Dalgleish

Before you protect the worksheet, select the cells that you want users
to be able to change.
Choose Format>Cells, and on the Protection tab, remove the check mark
from Locked, then click OK
To protect the sheet, choose Tools>Protection>Protect Sheet
Remove the check mark from Select locked cells
Click OK
 
Top