seeing formulas

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
Pressing Ctrl + ~ allows the formulas to be seen even if workbook is
protected.
Is there a way to privent the formulas from beeing seen?

Khalil
 
Hi Khalil,

In the Format>protection dialog, select Hidden.
The Tools>Protection>Protect Sheet

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

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

Similar Threads

No row or colomns a visibale 5
Countif 6
Copy Constants Only 1
Error: #DIV/0! 12
# DVD/0 3
VBA COde & Formulas 10
Continue Excel to New Uear 9
Lookup 5

Back
Top