Passwords #5

I would like to password protect a workbook so that when 
the workbook is selected to open a dialog box pops up 
asking for the password and after the password is entered 
correctly the workbook will then open.  Thanks for the the 
help. 

Todd
0
anonymous (74721)
1/12/2004 7:51:27 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
791 Views

Similar Articles

[PageSpeed] 0

Todd, do a save as and look under options, depending on what version you are
using and set a password to open

-- 
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"Todd" <anonymous@discussions.microsoft.com> wrote in message
news:050d01c3d945$777b83a0$a301280a@phx.gbl...
> I would like to password protect a workbook so that when
> the workbook is selected to open a dialog box pops up
> asking for the password and after the password is entered
> correctly the workbook will then open.  Thanks for the the
> help.
>
> Todd


0
pbridgesnews (182)
1/12/2004 7:58:50 PM
File / Save as - Then on the Tools button on the dialog box, hit Tools / General
Options and set it there.

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Todd" <anonymous@discussions.microsoft.com> wrote in message
news:050d01c3d945$777b83a0$a301280a@phx.gbl...
> I would like to password protect a workbook so that when
> the workbook is selected to open a dialog box pops up
> asking for the password and after the password is entered
> correctly the workbook will then open.  Thanks for the the
> help.
>
> Todd


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004


0
ken.wright (2489)
1/12/2004 8:02:28 PM
Hi Todd!

With Excel 2002 and 2003 two routes are now available:


Tools > Options > Security

Select from alternatives available

Impose or Change password

Re-confirm password or passwords

OK



OR (As before with Excel 2000)



File > Save As > Tools > General Options

Select from alternatives available

Impose or Change password

Re-confirm password or passwords

OK

Save

With Excel 97

File > Save As > Options
Check and enter as appropriate
OK
Save

-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.


0
njharker (1646)
1/12/2004 10:02:05 PM
Reply:

Similar Artilces:

Passwords #5
I would like to password protect a workbook so that when the workbook is selected to open a dialog box pops up asking for the password and after the password is entered correctly the workbook will then open. Thanks for the the help. Todd Todd, do a save as and look under options, depending on what version you are using and set a password to open -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address t...

Exchange 5.0 .vs 5.5 FQDN support
Hi doing an inplace upgrade of NT4 domain with existing Exchange 5.0. NT4 domain name "domain" Inplace upgrade of PDC is ok and in the Active directory wizard I change the domain name to company.corp.com. So I have a domain rename that I have heard is ok and the only time you really should change the domain name is here and now. Now I only have 1 BDC left and before i upgrade it i pull the plug on it to test log on and there is no logon servers available, using saved settings, only works when the last BDC is on the network. Netdom say PDC emulator is ok. Affects all clients towards...

Password Protect Two Sub-contact Lists
Hi everyone! I have a regular contact list, and within this list I have two subcontact lists. One is personal, and the other is personal business. How can I password protect the personal and personal business lists? Thanks for any help! Sorry, I just realized that there's a newsgroup dedicated to contacts. I'll post this there. Thanks! Nick2112@sympatico.ca wrote: > Hi everyone! > > I have a regular contact list, and within this list I have two > subcontact lists. One is personal, and the other is personal business. > How can I password protect the personal and...

eseutil #5
Exchange 2003. can i run “eseutil /k E01” when the databse is mounted and on line? and will this command check all the log files for consistancy? Thanks eseutil must be run offline. Checkling the log files addtionally requires ALL databases in the Storage Group whose log files you want to check to be offline. See http://support.microsoft.com/default.aspx?scid=kb;en-us;825088 -- Ben Winzenz Exchange MVP "Skipster" <Skipster@discussions.microsoft.com> wrote in message news:BA586876-AE43-4DA5-AE90-A533F5E584D0@microsoft.com... > Exchange 2003. can i run "eseut...

Passwords
Hi, I have a password field in a database. How do I set it so that a user can only type in 7 characters for a password. and if they type more an error message will appear? Please hi, Daz01 wrote: > Hi, I have a password field in a database. How do I set it so that a > user can only type in 7 characters for a password. and if they type > more an error message will appear? You may use the ValidationRule and ValidationText of the field in the table design view. Setting ValidationRule to Len([YourField])>7) will raise an error in your case. mfG --> stefan <-- ...

version compatibility between GP 5.5 and 6.0
Can I open a GP 6.0 file on GP 5.5? Thanks! Which file you are talking about? Naseer "mishra" wrote: > Can I open a GP 6.0 file on GP 5.5? > > Thanks! This is NOT recommended. Should you hit any tables that have been changed, you will have unpredictable results. -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users For help learning and better using Dynamics GP,... check out our books at http://www.AccoladePublications.com "mishra" wrote: > Can I open a GP 6.0 file on GP 5.5? > > Thanks! ...

Excel 2003 #5
Hi all Got a silly problem. MS Excel 2003 Professional via MS partner pack (aka Action Pack) Start Excel as normal, no problem, clik on FILE on the menu bar and Excel stops responding. ALL other menu items work correctly. I've un-installed and re-installed the software, no change. Excel WILL run in safe mode however. Any ideas anyone please. Thanks in anticipation, Adrian. PS I have an HP psc1215 attached and have noticed some mention of issues with their 'Share-to-web' rubbish that comes supplied (now un-installed) ...

Keep user passwords
Hi! We've just finished installing a new Exchange server and connecting it to a separate DC. We used to have everything on the same server but we'd like to be able to scale our solution better in the future - therefore the new setup. Users are primarily connecting to Exchange by means of RPC over HTTP from clients that are not part of our AD. The old setup allowed users to save passwords if they configured their clients to use NTLM authentication and followed the directions in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;820281. This worked both for RPC...

How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the password. Is there any way that I can gain access to my worksheet? There are tons of FREE good Excel password 'cracking' tools. Your favorite search engine should get about a gazillion hits on a phrase like "crack excel password" or "excel password cracker". A good one that many report great success with can be found at: http://www.straxx.com/excel/password.html "Laurie" wrote: > I password protected an Excel spreadsheet and now can't remember the > p...

using orf enterprise edition with exchange 5.5 running on Windows 2k server
Hello Fellows, We run one exchange 5.5 server on a windows 2k server box...we use scanmail from trend to quarantine viruses and attachments server side...up until recently (before I started this job) we where also running scanmail emanager to filter spam...emanager was turned off because it was bogging down the server and was not very efficient...I don't know this for a fact because emanager use was terminated before I started...now users want spam filtering again...so my choices are get emanager up and running again or find cheap alternative....orf is reasonably priced (100 bucks per ser...

Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help section. You can prevent un authorised access by giving a password to open the workbook itself, so that no one else can open it (Go to Tools, Options and then Security Tab). You can do it there if you have already saved the file, or you can go to "save as" then "Tools" and "General Options" where you can give password. On the other hand you can protect work sheets and ranges for different people by using "Tools" and then "Protection" Tab -- M Imran Buha...

Password
I am working with publisher 2007. I finished my site last Dec. and went to make changes. It is not letting me make changes because it does not like my password. I can not figure out how to go in a reset everything from my provider. Any suggestions. I was also trying to see if I could find web publishing wizard, which doesn't seem to exsist with 2007. Thanks If you are saying you forgot your password then contact the ISP Tech Support and they will reset the password to something like 1 2 3 4 or something other that is very simple. They will also instruct you to change it to somethin...

Exchange 5.5 #34
I have taken over a new position and they have had no luck in the past with sucessful incremental backups of the system. In the light of things, the previous administrator deleted a known viable user account from Exchange administrator. Since then, is there a way to just restore that single account from a known first full backup. Also where are the mailboxes stored? I thought they were in the Inetpub folder within the exchange folder? Any assistance would assist.. Thanks David "David" <dabrobst@verizon.net> wrote: >I have taken over a new position and they have h...

Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a user. my client want to know how to enable it. hope for your prompt action. -- Jeremy Ayaay Technical Specialist STRC Only works for SQL 2005. If you client wants to use a beta database server... "Jher" wrote: > I'm curious why are the Change Password Next Login, Enforce Password Policy > and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a > user. my client want to know how to enab...

Passwords #3
Using outlook2002. For some reason, it will not store the password. I have checked the box that says "remember password", but, each time I try to log in. It will ask me for it. Any ideas. I am thinking about recreating the profile for thismailbox. I am a consultant, and my customer doesn't know how (or won't write down what I tell them) to do this. Thanks ...

password prompt when no password is set.
thru a series of unfortunate events I had to reinstall my os and all of my programs. I was using ms money 2000. I have always kept the main *.mny file but lost my backups. When i reinstalled money and tried to open my mny file I get a password prompt. I have never password protected the file and when i tried to run a password recovery program it says "no password set". I do have older backups of this file but they are too old to be of much use. But i am able to access them. any suggestions would be appreciated. Thanks BRC The password prompt often appears when you open a dataset m...

I have great plains v 7.5 with 3 users, all users are locked
All 3 users are locked, and i caan't log on to delete users activity, is there any other way to go to user activity and terminate the activity of the 3 users. Thanks delete from ACTIVITY on Dynamics database. >-----Original Message----- >All 3 users are locked, and i caan't log on to delete users activity, is >there any other way to go to user activity and terminate the activity of the >3 users. > >Thanks >. > Or, if you are on a Pervasive system, find the Activity.btr file, in the System folder and rename it. Lyle On Sat, 2 Oct 2004 11:53:10 -0700,...

Network password #9
I don't use passwords and now i am prompted to enter a network password or my computer will not connect to email account. Any thoughts If you are still having problems after applying both the SP 1 & 2 patches, then see if this article addresses your problemL OL2002: The Save Password Setting Is Not Saved When You Connect to a POP3 Server http://support.microsoft.com/default.aspx?scid=kb;en-us;290684 --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal accoun...

How to password protect a selection using the autofilter function?
Hi, Could anyone tell me how I can password protect a selection from using the autofilter option in Excel 2000. The purpose of this is that I have a file that has some data under a couple of people's names. I want the person who selects the data under his/her name to be prompted for a password so only that person can view the data. I know i can seperate the data and send it individually, but if I can do the above, then that would save me some time. If anyone know how to do that please email me at yuppie931@yahoo.com. I really appreciate it. I am not sure if I need to do a VBA or there is...

Password Problem #9
I continioulsy get a popup that says "Enter Network Password" the box show my server, username and password. this box pop up every few seconds. My intenet provider (TimeWarner) says this is an Outlook problem. does anyone have a solution? Thanks -- MikeM "MikeM" <MikeM@discussions.microsoft.com> wrote in message news:27BD7829-84BD-44BD-9114-3FF4D453BD72@microsoft.com... > I continioulsy get a popup that says "Enter Network Password" the box > show > my server, username and password. > > this box pop up every few seconds. My inten...

A/P A/R Lookup windows v 7.5
We just upgraded to 7.5 from 6.0 and are having an issue with the vendor, customer and item lookup windows. We have 2 different companies set up. One company's lookup window looks like version 6.0 and the other company looks very different and does not sort the same as 6.0 did. There are more steps involved. We also did a test upgrade and this lookup window difference was not an issue. In fact both companies in the test version had the old lookup window which we really prefer. Has anyone else had this issue. I would appreciate any suggestions. Thank you. I ran into this whe...

Password Protection #5
Hi all I have a spreadsheet with several sheets . These are accessed via macr buttons on a main fron sheet (I have hidden other sheets) . Is i possible to password protect certain sheets so that they cannot b accessed by the user without the correct password . I can protect the so that they cannot be changed but need to stop them from bein accessed Thanks Kiera -- Message posted from http://www.ExcelForum.com First Hide the sheet by going Format/Sheet/Hide on the toolbar. If you then protect the workbook structure the user will be unable t unhide the sheet. Dunca -- Message posted fr...

No Password
How do we get into another person's Outlook Express identity without their password? An employee has left the company abruptly. There are important email messages that we need access to in their account but we don't have the password for their identity. I don't see an option for the administrator to re-set the password. How can we get in and get those emails??? lier lol ;O "J" <anonymous@discussions.microsoft.com> wrote in message news:8c6901c4859f$0fdcf650$a401280a@phx.gbl... > How do we get into another person's Outlook Express > identity withou...

CHANIGN PASSWORDS IN OWA
Hello. I've got a pretty simple config. Exchange 2003, single server. I have the change password option setup in OWA, but when users click the button they are prompted for their credentials again, even though they've already logged in. How can I prevent this from prompting them and just have it pass the credentials through? Thanks. Check the security settings on the IISADMPWD virtual directory. See if this helps: http://support.microsoft.com/kb/297121/en-us -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Dan" <Dan@d...

Blank Cells #5
I have a 300 row column with values in some of the rows. How can I select the column range and insert 0.00 into all blank cells? Hi Josh select your column then choose edit / goto and click the Special button choose blanks click Ok type 0.00 and press control & enter this should put it into every selected cell - if the formatting is not correct, change the formatting before you click on another cell to unselect the range. Hope this helps Cheers JulieD "Josh" <Josh@discussions.microsoft.com> wrote in message news:D1BD90DF-3B1D-4E13-BE8C-B82B1CC8F5F0@microsoft.com.....