Technology Questions

Go Back   Technology Questions > Software Questions > General Questions > Microsoft Office

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 06-20-2007, 08:21 AM
Natty
Newsgroup Contributor
 
Posts: n/a
Advanced password protection in Word, Powerpoint and Excel

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!
--
Nat
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

 
Old 06-20-2007, 08:21 AM
  #2 (permalink)  
Old 06-20-2007, 08:40 AM
db ´¯`·.. >
Newsgroup Contributor
 
Posts: n/a
Re: Advanced password protection in Word, Powerpoint and Excel

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.....


--

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



..


"Natty" <natwykes********.com> wrote in message
news:876B26E9-6258-4B04-AA8F-D15D7E864DF2@microsoft.com...
> 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!
> --
> Nat


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

  #3 (permalink)  
Old 06-20-2007, 08:50 AM
Natty
Newsgroup Contributor
 
Posts: n/a
Re: Advanced password protection in Word, Powerpoint and Excel

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.
--
Nat


"db ´¯`·.. ><)))º>` .. ." wrote:

> 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.....
>
>
> --
>
> db ·´¯`·.¸. , . .·´¯`·..><)))º>`·.¸¸.·´¯`·.¸.·´¯` ·...¸><)))º>¸.
> ><)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><))) º>

>
>
> ..
>
>
> "Natty" <natwykes********.com> wrote in message
> news:876B26E9-6258-4B04-AA8F-D15D7E864DF2@microsoft.com...
> > 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!
> > --
> > Nat

>
>

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

  #4 (permalink)  
Old 06-20-2007, 12:10 PM
db ´¯`·.. >
Newsgroup Contributor
 
Posts: n/a
Re: Advanced password protection in Word, Powerpoint and Excel

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...


--

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



..


"Natty" <natwykes********.com> wrote in message
news:74FE31EB-C7F3-4FCC-8E52-3E9A55303C7F@microsoft.com...
> 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.
> --
> Nat
>
>
> "db ´¯`·.. ><)))º>` .. ." wrote:
>
>> 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.....
>>
>>
>> --
>>
>> db ·´¯`·.¸. , . .·´¯`·..><)))º>`·.¸¸.·´¯`·.¸.·´¯` ·...¸><)))º>¸.
>> ><)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><))) º>

>>
>>
>> ..
>>
>>
>> "Natty" <natwykes********.com> wrote in message
>> news:876B26E9-6258-4B04-AA8F-D15D7E864DF2@microsoft.com...
>> > 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!
>> > --
>> > Nat

>>
>>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can not use Word, Excel or Powerpoint 2003 Chase Microsoft Office 3 03-31-2008 05:10 PM
Excel Password Protection - Help? ArtGle Microsoft Office 1 11-09-2007 07:50 AM
Excel Doc Password Protection Cary K Microsoft Office 1 10-04-2007 03:50 AM
RE: Word/Excel/PowerPoint: Slow to Start Merg to the max Microsoft Office 1 01-31-2007 02:15 PM
Where can I download gif icons of Word, Excel, & PowerPoint? j1n Microsoft Office 1 01-15-2007 11:36 AM


New To Technology Questions? Do You Need Help with Your Computer or Device? Do You Need Help with this site?

All times are GMT -8. The time now is 08:30 PM.


2003 - 2009 All Rights Reserved. Technology Questions

Search Engine Friendly URLs by vBSEO 3.3.0