+ Reply to Thread
Results 1 to 5 of 5

Password protected viewing

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Port Macquarie
    MS-Off Ver
    Excel 2010
    Posts
    1

    Password protected viewing

    Okay, newbie here

    is it even possible to have a spreadsheet with approx 20 worksheets on it, but have it so when someone opens it they are asked to put in a password and dependant on that password is what sheets are able to be seen. All sheets will be read only.

    Does that make sense?

    Darryn

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Password protected viewing

    Hello darryn1969,

    Welcome to the Forum.

    Yes it is possible. Show us what you have so far, by uploading a sample WorkBook, and we will take it from there for you.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Password protected viewing

    something to get you started:

    http://www.excelforum.com/showthread...=1#post3195333

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Password protected viewing

    @ nickmax1,

    I had forgotten about that one!

    Thanks for reminding me.

  5. #5
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Password protected viewing

    hehe - thats what I am here for Winon!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. My password-protected vba code is locked for viewing...
    By Stu M in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-25-2009, 04:51 AM
  2. Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. Replies: 1
    Last Post: 06-23-2005, 08:05 PM
  5. Replies: 0
    Last Post: 06-23-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1