Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

safely hide or protect data in Excel

1

Hi, I just saw this tutorial on your site:

https://www.teachexcel.com/excel-tutorial/hide-data-within-a-worksheet-in-excel_1413.html

I was wondering if there was a secure or safe way to hide data in Excel so that users who shouldn't be able to see it can't see it.

At the bottom of the tutorial says that I can "protect" the worksheet to keep it secure but what if I want to hide the entire worksheet and prevent a user from seeing it. How do I do that since you can right-click the sheet tabs and show hidden worksheet?

excelsecurity
MS Office Version: 2010
posted by: chriswall (rep: 6) on Tue Apr 11, 2017 at 5:38 am
Answer
Discuss

Answers

0
Selected Answer

See this:

https://www.extendoffice.com/documents/excel/1276-excel-very-hidden.html#a1

posted by: sahak (rep: 10) on Fri Apr 14, 2017 at 6:25 pm
Discuss

Discussion

sahak, when you post here, make sure to include the steps that solve the issue instead of just posting a link to a tutorial; at least you need to provide a summary. Links can be broken in the future or the website could be shutdown and people who come here should still be able to get the correct answer.
cappymer1 (rep: 120) Apr 16, '17 at 2:24 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login