Solved

Password Protect Excel Single Worksheet

Posted on 2013-12-23
1
365 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 49

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
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 walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 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