security of a cell

  • Thread starter Thread starter chimp
  • Start date Start date
C

chimp

is it possible to protect a range of cells, so that it i wanted to
change them a box could appear requesting the password to access the
cells.

i would idelly like to set this up so that the need to go through the
top menu is bypassed.
 
This was added in xl2002 as a built in feature.

Before that version, you'd need a macro. And if the user opened the workbook
without enabling macros, it wouldn't be effective.
 
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

News Encrypted SSDs are not as secure as we thought 3
Cell Security 1
Code to format cells on several worksheets 2
Tabbing Order of Unproteced Cells 3
Excel Typed text appears in wrong cell 0
Security and macros 6
How to change format protection default to unlocked? 2
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top