preventing a workbook being changed? (not as simple as it sounds!)

  • Thread starter Thread starter neowok
  • Start date Start date
N

neowok

i am trying to prevent anyone being able to make changes to a workboo
and something strange is happening.

Ive put a password on the workbook by going to tools/options/securit
and adding a "password to modify".

now in theory this should prevent anyone ever being able to change m
workbook without knowing that password.

however ive had the workbook put onto the intranet, clicking the lin
to it opens it in IE. if i make some changes in the workbook and the
click the back button in IE, i get prompted to save the workbook due t
changes. I can then click save and save the workbook to my disk. if
then try to open the workbook from my disk, I get no password what s
ever and can change anything I like.

anyone know what the hell is up with that? I mean the whole idea is w
dont want invalid versions floating around that people have saved o
the intranet and somehow the password is vanishing as soon as its save
to disk from IE after viewing it on the intranet
 
ive just realised it isnt even the process of saving the file that
causing the password to vanish. The password is on the file here.
emailed it to our intranet guy to put on the intranet and when openin
it on the intranet, the password has miraculously vanished into thi
air!!!!!!!!!

the thing is i dont really want to protect everything like that as
will have to unprotect it al the time to update it (which is severa
times a day). I dont know how the password i set vi
tools/options/security is vanishing into thin air, it really shouldn
be
 
Neowok,
I can not replicate your situation.
My workbook is locked, following (alowable) changes it
does not prompt for "saveing".
take us through your process.
Dingo
 
If you do find you have to go through the protection rigmarole, it'
worth doing the worksheets in a sub in This Workbook which runs o
opening.

Al
 
just cannot work out how emailing a workbook to the intranet manager
then him putting it on the intranet can make the password vanish
 
Back
Top