|
| |||
| 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 |
| |||
| 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 |
| |||
| 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 > > |
| |||
| 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 >> >> |
| Bookmarks |
| Thread Tools | |
| |
| | ||||
| 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? |