Solved

Password Protect Excel Single Worksheet

Posted on 2013-12-23
1
370 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 51

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

752 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