Advanced password protection in Word, Powerpoint and Excel

[Natty]

Hi,

I have just discovered that in MS 2003 you now have the option to use strong
encryption options when password protecting documents by going to the Tools >
Options > Security section. What I would like to do is to create a Macro to
save onto our company global template which will basically take people
through to the Security option and automatically select the strong RC4
encryption level in advanced and then wait with cursor in the password
section so they can go ahead and input a password and click OK. I have tried
to record a macro to do just this but it will not let me just get to the
stage of selecting an advanced level of encryption and then stop recording.
Can anyone suggest a way of me being able to do this? If I cant can anyone
let me know how I can make the strongest level of encryption a default for
password protecting documents? Any help at all would be really appreciated!

 

[db ´¯`·.. >]

there are a couple of
methods that can be utilized.

however, i "really" have a question
about making every single corporate
document and file password encrypted
at the convenience of every employee
and their preference to what password
they will decide to use and select....

i hope you can understand that from
my perspective, it seems that this
is a mal attempt to create a security
screen that is prefilled and covertly
used without the users knowledge

maybe if you further explain as to
why the standard security features
or methodology used for all businesses doesn't
meet your needs.....


--

<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>

..

 

[Natty]

we work with a lot of share price sensitive information and whilst we do not
want all of our documents to be password protected there are ones which we
certainly need to protect. As the standard passwords are easily crackable
our Head of IT would like everyone to be able to use the advanced options
however as a lot of our staff are not that IT literate actually asking them
to use this proves difficult so if we can get a Macro in place that would be
the best course of action. We do not want to use this covertly. It is just
really an aid so that anything we do need to password protect can be done so
using strong and more uncrackable methods. I hopoe that explains what we are
trying to achieve.

 

[db ´¯`·.. >]

ok,

lets take a look at your macro
and maybe we can review it
and modify it to complete
the tasks.

when you record the macro
it creates the visual basic
programming code.

you can see the verbiage/code
via the macro menu option.

you can select the macro then
click on edit to see the program
inside a visual basic editor.

in this editor is where the
macro can be finalized by manually
writing end the desired commands.

as you mentioned, you were able
to create a macro until you got to
a certain point. well, this is where
the editor comes in handy because
it will allow you to manually finalize
whatever macro coding you had tried
to create. further by using the editor
any macro can be fine tune and excess
codes can be eliminated or combined.

since you have already formulated that
your macro is a preferred method, then
it would be easier to help you finalize it.

therefore, if you have not done so already, go ahead
and recreate that macro to the point that
allows you to stop recording. then access
the editor and copy whatever code has been
recorded and paste in your response.

like most everything there are several
ways to write code that would accomplish
the same task.

for the method above, go ahead and use
word as the program to focus the macro
on...


--

<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>

..