hiding formulas and defined names in a worksheet

  • Thread starter Thread starter alldreams
  • Start date Start date
A

alldreams

Is there a way to password protect formulas in cells and
Defined Names?

Thanks for your help

Johann
 
Hi Johann
- goto 'Tools - Protection'
- protect your worksheet and workbook
 
In defined names, you can hide them. for cells, you can check the hidden
and locked properties and then protect the worksheet.

Password protection on sheets is pretty easy to break however.
 
how is it easy to break? examples?
-----Original Message-----
In defined names, you can hide them. for cells, you can check the hidden
and locked properties and then protect the worksheet.

Password protection on sheets is pretty easy to break however.

--
Regards,
Tom Ogilvy




.
Click to expand...
 
Code is posted here about twice a week to remove worksheet protection. I
can give you a URL where you can download a free addin to do it.
 
please send me the URL.

thanks
-----Original Message-----
Code is posted here about twice a week to remove worksheet protection. I
can give you a URL where you can download a free addin to do it.

--
Regards,
Tom Ogilvy




.
Click to expand...
 
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

Excel VBA 1
Vba Help with Information Extraction 0
using defined name in UDF 7
Application.Selection.Name gives "=Sheet3!$A$1"; I want the name 9
Runtime error 1004 when trying to insert formula in cells 11
Defined Name Formula 2
Assigning a worksheet name to a variable 3
Using code to edit spreadsheet formulas 5

Back
Top