bob12a Posted February 11, 2009 Posted February 11, 2009 I have a spread sheet I wish to password protect. I use Roboform Pro for all my log on protection but it seems I cannot produce a password this way Any ideas please I have put this request as I think is would count as security Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 11, 2009 Posted February 11, 2009 What version of Office are you using Bob? Quote
bob12a Posted February 11, 2009 Author Posted February 11, 2009 Am using openoffice3 for this particular file. Its part of the teaching I am giving my friend who is just learning and I did not want to bog him down My MS 2007 Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 11, 2009 Posted February 11, 2009 Is he using XP or Vista? If XP save the file with a given name and Save As box will pop up. In Tools to the right click General Options. In the File Sharing and Password to Modify enter a password then click ok. Quote
bob12a Posted February 11, 2009 Author Posted February 11, 2009 He is using VISTA You may be remembering I wanted to change his lap top to XP but in the end followed your advice and stuck him with Vista Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 11, 2009 Posted February 11, 2009 Ok go to Tools, scroll down until you see Protect Document. A side box will open, choose Protect Document. If you choose Protect Sheet it will protect that sheet only and not others that may be in the Document. Enter a password and then confirm it then click OK. Quote
bob12a Posted February 11, 2009 Author Posted February 11, 2009 Wolfey thanks I know how to do that so I did not explain myself. What I would like to do is not to be able to OPEN the spread at all without using a password. Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 11, 2009 Posted February 11, 2009 Sorry I was mistaken in my earlier post, you need to enter a password for both Sheet and Document. Quote
RandyL Posted February 11, 2009 Posted February 11, 2009 Hi Bob. I can't find a way to do that either. As you noted you can still open it but not change it without a password. Prior to Vista you could put the file in a folder then compress the folder and password protect the compressed folder. Unfortunately password protecting a compressed folder option was removed from Vista Home Premium. It is available in Business or Ultimate or both. I forget which ones. For that matter they may even be able to protect a file itself in one or both of those versions. What version of Vista does he have? There are third party tools to password protect but I have not personally tried them. There may be risks involved with that such as what happens if the hard drive fails. Quote We are all members helping other members. Please return here where you may be able to help someone else. After all, no one knows everything and you may have the answer that someone needs.Get help with computer problems. Join Free PC Help here Donations are welcome. Read Here
bob12a Posted February 12, 2009 Author Posted February 12, 2009 Thank you both very much Wolfy It protects the document and the sheet but does not stop someone opening the file and VIEWING it RL What version of Vista does he have? Ultimate Later on in the day I am thinking of trying to put a shortcut file in the safe notes of Roboform Pro. Will let you know what happens Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 12, 2009 Posted February 12, 2009 Please re-read post No 8 Bob Quote
RandyL Posted February 12, 2009 Posted February 12, 2009 Encrypting File System from Microsoft Beware though as you may not be able to retrieve these files in the future should something go wrong with the computer, hard drive or user account. Quote We are all members helping other members. Please return here where you may be able to help someone else. After all, no one knows everything and you may have the answer that someone needs.Get help with computer problems. Join Free PC Help here Donations are welcome. Read Here
bob12a Posted February 12, 2009 Author Posted February 12, 2009 Wolfey What you say is correct it protects the sheet and document but this just stops anyone from changing anything in the spreadsheet It is not what I am trying to do I am trying to stop the spreadsheet from being opened in the first place without the use of a password Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 12, 2009 Posted February 12, 2009 Bob its easy to do ok. 1: Password protect both Sheet and Document. 2: Save (Save As) the whole thing with a file name and it will immediately ask you for the Password. Now when you come to open that file again it will ask you for the Password and NO data will be showing until you input that Password. This applies to either if you open it in Calc or from where the file is stored. Quote
RandyL Posted February 12, 2009 Posted February 12, 2009 Hi Bob; After extensive testing by Wolfeymole and myself we have isolated the problem as to why we and you see and have different options. In order to not SEE the password protected Open Office document you need to update Open Office to version 3.0.1 Once you do that it will work if you select to password both the sheet and the document. Quote We are all members helping other members. Please return here where you may be able to help someone else. After all, no one knows everything and you may have the answer that someone needs.Get help with computer problems. Join Free PC Help here Donations are welcome. Read Here
Guest Wolfeymole Posted February 12, 2009 Posted February 12, 2009 It is not what I am trying to do I am trying to stop the spreadsheet from being opened in the first place without the use of a password If I read this right Bob it's just not logical mate, what other method would there be to stop the document being opened without the use of a password? Quote
bob12a Posted February 12, 2009 Author Posted February 12, 2009 Fairly certain you have between you solved it for me thanks very much now when I try to open file it asks for a password just as I want it to do Regards Quote Bob(bob12a)My 3D pictures need red cyan glasses to viewmedion MD8855,Win 7 IE8, Firefox/3, Avast,MS security essentials, NERO 9,malware bytes.Mailwasher pro ,6.54,Roboform,spybot S&D 1.6, Canon ixus 860 X 2,PS CS5
Guest Wolfeymole Posted February 12, 2009 Posted February 12, 2009 But I thought....................:confused: Oh well never mind, good to see you are ok now Bob. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.