Simple Questions

  • Thread starter Thread starter cgi_pro
  • Start date Start date
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)?
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top