By restricting access to the registry settings?

Tim

--
Tim Williams
Palo Alto, CA


"NickHK" wrote in message
...
Bob,
What I mean is how would they "remove the ability to change it" ?

NickHK


"Bob Phillips" wrote in message
...
They would install Excel with a high setting, and they can remove the
ability to change it.

--
HTH

Bob Phillips

"NickHK" wrote in message
...
Bob,
How would an admin lock the user's security setting at high ?

NickHK

"Bob Phillips" wrote in message
...
Mangesh,

Many system administrators will restrict the functions of products
and
the
OS, so that the average user is functionally crippled, as part of
company
policy. Such restrictions include the ability to set date and time,
to
add
system variables, etc., and within Excel to run macros by setting
the
security setting to high and stopping the ability to change that.

In this instance, if you want to manipulate Excel spreadsheets via
code,
I
think you will have to do it externally via automation. That is,
create
an
application using an approved tool, such as VB, that uses Excel as a
server
app, and manipulates it from within your app. It is very
straight-forward,
the main learning exercise is to be aware of which object you are
addressing, and reference properly at all times.

Of course, this still leaves the problem that the user will not be
able
to
install it, the CD drive will be disabled as well if not even
sealed,
so
you
will need the co-operation of the system administrators for that.
They
might
say no, they might say yes but insist on testing it themselves, or
they
might say yes. As you need their co-operation, you could also ask
them
about
whether they would install a COM add-in, or a simple Excel add-in.
Whatever
way, your first action should be to discuss with them, otherwise you
might
just be wasting your time and effort.

--
HTH

Bob Phillips

"Mangesh Yadav" wrote in message
...
Hi Everyone,

I have a spreadsheet which uses macros extensively. Now if a
particular
company has a policy which does not allow macros, what is the
alternative
for my spreadsheet.

I know the question is bit unclear regarding the policies, but
even
I
don't
know how this is done. Another question I have is: when a
particular
company
says that it does not allow macros, what is it that they do to
prevent
the
user from allowing a macro to run. (Is it something like they
disable
the
Tools Security feature...?)

Thanks in advance.

--
- Mangesh
------------------------------------------
Office XP & Windows XP