security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

right now i have a add-in forms in sheet1, where new datas can be saved
inside sheet2.
Inside sheet2, am i able to secure and prevent (let say 2 columns) users
from editing?
 
Sure, select all cells and unlock them (Format>Cells>Protection), then
select those columns and lock them (Format>Cells>Protection again), and
protect the sheet (Tools>Protection).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
can i have a simple secure like how to prevent users from editing sheet2?

Right now i have a add-in forms in sheet1, where new datas are be saved
inside sheet2.

I try to lock sheet2 then i cant add in new data from sheet1.

Any1 can helps?
 
have read solution like:
tools|Protection|protect workbook|make sure the Structure box is checked.
That does help.

But how come
That said, this kind of workbook protection is easily broken?
 
Excel internal sheet and book protection is quite weak.

Password-cracking programs are many and readily available from the Internet.


Gord Dibben MS Excel MVP
 
Back
Top