Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Setting Password At Microsoft Excel


  • Please log in to reply
3 replies to this topic

#1 jums48

jums48

  • Members
  • 17 posts
  • OFFLINE
  •  
  • Local time:03:07 AM

Posted 27 October 2006 - 03:49 AM

Does anyone have any idea on how to set a password at microsoft excel. Suppose a document contains information that can be viewed by anyone, but should be modified only by a limited number of users. In this case, the author requires a password to modify. A user who does not know the password can view the document and make changes, but cannot save these changes to the document. However, you can get around this type of protection by using the "Save As" command and saving the document under another name. The password to modify will be reset in the newly-saved document.

Appreciate if anyone have an idea on how to set that as my boss ask me to set a password for some of the document in my office.

BC AdBot (Login to Remove)

 


#2 Animal

Animal

    Bleepin' Animinion


  • Site Admin
  • 35,292 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Where You Least Expect Me To Be
  • Local time:01:07 AM

Posted 27 October 2006 - 12:55 PM

You can set a password to open either for a new document by going to Save As > Tools > Security Options or for an existing document Main Menu > Tools > Options > Security.

For a more thorough explanation see this article.

Be (under Lock and Key) Safe

Da Bleepin AniMod, Animal

The Internet is so big, so powerful and pointless that for some people it is a complete substitute for life.
Andrew Brown (1938-1994)


A learning experience is one of those things that say, "You know that thing you just did? Don't do that." Douglas Adams (1952-2001)


"Imagination is more important than knowledge. Knowledge is limited. Imagination circles the world." Albert Einstein (1879-1955)


Follow BleepingComputer on: Facebook | Twitter | Google+

#3 jums48

jums48
  • Topic Starter

  • Members
  • 17 posts
  • OFFLINE
  •  
  • Local time:03:07 AM

Posted 27 October 2006 - 03:12 PM

ohh......i will try that out when I in my office. Thanks alot

#4 Animal

Animal

    Bleepin' Animinion


  • Site Admin
  • 35,292 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Where You Least Expect Me To Be
  • Local time:01:07 AM

Posted 27 October 2006 - 09:48 PM

You are quite welcome. If you have any problems please post back. Or if it works, post back too. So that others will know if this may be of use for them as well.

Be Safe

Da Bleepin, Animal

The Internet is so big, so powerful and pointless that for some people it is a complete substitute for life.
Andrew Brown (1938-1994)


A learning experience is one of those things that say, "You know that thing you just did? Don't do that." Douglas Adams (1952-2001)


"Imagination is more important than knowledge. Knowledge is limited. Imagination circles the world." Albert Einstein (1879-1955)


Follow BleepingComputer on: Facebook | Twitter | Google+




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users