macro security 1

[autex]

I've written a nice spreadsheet full of macros of code to help us here at work. Nobody else can open it on their computer because security is set to high. I've written a database full of macros ad vba and everybody can open it just find. Why one and not the other??

 

[PHV]

The macro security level is set on application basis.
It may be high in Excel, medium in word and low in access.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[autex]

ok, interesting, I'm trying to find out where to check my security levels on both. I think I've found it in excel pretty obvious, all I see in access is the user and group stuff. I haven't set any of that up. Any advice?

 

[autex]

for access 2002?

 

[PHV]

Macro security level in access only since 2003 version.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[autex]

Thanks man, you gave me enough info to solve my problem.