Solved

Password Protect Excel Single Worksheet

Posted on 2013-12-23
1
367 Views
Last Modified: 2014-01-04
Happy Holidays!

Is it possible to password protect (from viewing) a single worksheet in an Excel 2010 spreadsheet? In other words...

I have a spreadsheet with 5 worksheets in it. I want to password protect one of the sheets so anyone who tries to view it will be unable to do so.

Thanks...
0
Comment
Question by:pcwizz1
1 Comment
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 39736623
Hi

Even  if the security of such a Password pretty low you could use in XL2010

set your sheet as veryHidden ( it is only visible in the VBE

Sub Macro1()
ThisWorkbook.Sheets(1).Visible = xlSheetVeryHidden
End Sub

Open in new window


And protect your Project with a password

Regards
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question