How do I disable tools option when a file opens.

Thank you,

Steven

Virus! Hey, we've got a malware-writer here! Where's a cop when you need one?

Ok, seriously: Why would you want to do that?

--- "Steven" wrote:
How do I disable tools option when a file opens.

I do not want a user to change any settings or get into security.

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.

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.

Yeah, I understand, and sometimes I try to fix things so my users can't
accidentally shoot themselves in the foot, too. In fact, with some sheets it
pays me to do the same thing for myself.

--- "Steven" wrote:
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.