We are not connecting here. I do not have a problem with a virus and is not
what I am discussing here.
Empower them? My users are dangerous and hobble themselves and the company
when using a file because they lack excel skills. They are good little mice
and you have to direct them through the maze. You have to force what they do
in the file just as if it was an access program as best possible. Therefore
I have to build passwords and limit their menu access. For example on some
files I do not allow SaveAs and I do not allow them to go to the Menus.
Basically everything they need to operate the file is done with forms and
command buttons or other code. Thats just the way business is and the way
excel is used. They like it also because the system stops them if they are
doing something they shouldn't and it helps all the way around. There are
password crakers on the internet but they would not do that because it would
not be beneficial to them, they do not know how to do it, I have many catches
that they would trip on and they would not like the consequence. They just
want to have a good job and be told what to do.
I did figure out what I needed.
Steven
"Bob Bridges" wrote:
Well, truthfully, I sympathize. But as I see it, our job is to give our
users options, to empower them not hobble them. There may be a way to do
this - I wouldn't be surprised, anyway - but I've never tried.
Besides, the very first piece of virus code I ever examined was in some
flavor of VB - VBA/Word, I think it was - and one of the first things it did
was remove some user option from the menu so a naive user wouldn't easily (or
at least accidentally) find an option that would help him defend himself
against further infections. That was a long time ago, but I guess it marked
me. I'd have to really want it to go looking for the way to do it now.
Maybe someone else will tell you whether it's possible.