-1

Possible Duplicate:
Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel

I have set of excel sheets with macros. Now i want to hide the tabs like Review and Developer so that users can't do modifications to the code. I know that File->Options->Customize Ribbon->Select Tab->Enable\Disable->Click Ok hides the tabs but any user can unhide the tabs with the same process. So i want an alternative way to restrict users to unhide Tabs which are hidden.

Community
  • 1
  • 1
SaiKiran Mandhala
  • 365
  • 2
  • 14
  • 37
  • [Post1](http://stackoverflow.com/questions/259897/how-password-protection-of-excel-vba-code-works). [Post2](http://stackoverflow.com/questions/259663/vba-password-protection-how-it-works-is-it-secure-are-there-any-alternatives?rq=1) and if you notice to your right hand side the `related` posts there are a tons of them. Frankly when you were posting this, wish you could check on those ;) – bonCodigo Jan 08 '13 at 10:42
  • look http://stackoverflow.com/questions/4043468/hiding-a-sheet-in-excel-2007-with-a-password-or-hide-vba-code-in-excel – Gangnus Jan 08 '13 at 14:52

1 Answers1

1

Am, it would be better to protect the VBA files directly, so a user needs a password to modify them. This should be found in the left-hand properties menu in the VBA-Editor

Christian Sauer
  • 10,351
  • 10
  • 53
  • 85