Excel/Password to edit

Advertisement


Question
QUESTION: Hi, i have create a Excel for my Customers and each Customer has a password in which the Excel will only Unhide the specific Spreadsheet. I need 3 things
Firstly I dont want them to be able to see my formula.
Secondly I dont want them to be able to edit.
Thirdy, and most important, I dont want them to be able to "view code". And some IT might be able to view all spreadsheet. Hence i need to disable "right click"

How can it be done? However, a password will be needed when opening the excel which will enable all these.

ANSWER: Your question is very long and involved, and though i've seen many people do this, none of it worth the effort.  It takes only about 10 minutes of "googling" to come up with easy workarounds to circumvent every one of the security tricks you've outlined.

Excel is not a secure environment.

---------- FOLLOW-UP ----------

QUESTION: Okok. Anyway, I have "protect" individual spreadsheet and Hide them. however, when i click "File". Under "Permission". It write "One or more sheet in this workbook have been locked to prevent unwanted changes to this data"

And it shows the whole list of Hidden spreadsheet. How can I make it not to show the list?

Answer
This is a known design flaw in Excel.  The way to hide a sheet so a user cannot see it is to hide using VBA using the xlSheetVeryHidden flag.  This means the ONLY way to unhide the sheet again is to use VBA, it cannot be done by hand.

         Sheets("Sheet2").Visible = xlSheetVeryHidden

Now there's no need to "protect" that sheet, it's "Very well hidden". Do not protect it and it won't show up in the Permissions list, thus revealing its existence.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Jerry Beaucaire

Expertise

Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files

Experience

Microsoft Excel MVP - 2010. I have my own extensive Excel help/code site: http://sites.madrocketscientist.com/jerrybeaucaires-excelassistant/files ===================== I have been offering free assistance as an Excel aid on many web sites for many years: (http://www.excelforum.com - JBeaucaire) ======== (http://www.askmehelpdesk.com/spreadsheets - JBeaucaire) ======= (http://www.mrexcel.com/forum - jbeaucaire)

Education/Credentials
Bachelor's Degree from Azusa Pacific University in Mathematics and Music Composition

Awards and Honors
Microsoft Excel MVP 2010

©2016 About.com. All rights reserved.