dsdemo.blogg.se

1. #Reveal hide tabs on excel for mac using vba how to#
2. #Reveal hide tabs on excel for mac using vba password#

First, start by hiding the sheet (or sheets) that you'd like to make invisible.

#Reveal hide tabs on excel for mac using vba how to#

Here's how to use it to really hide a worksheet within a workbook. I hadn't heard about this feature until I went to research my wife's question on hiding a worksheet within a workbook.

#Reveal hide tabs on excel for mac using vba password#

Note that this is different than protecting cells so they can't be changed, and it's different than protecting your workbook by requiring a password to access it. The real answer is to use an Excel feature called Protect Workbook. Great, except…unhiding a sheet is as easy as choosing Unhide from that same contextual menu. Hide a sheet, and poof, it's gone, but all formulas that refer to the sheet still work. The answer would appear to be the Hide menu that appears when you right-click on a sheet. So how can you distribute the workbook to all the departments, with the salary info intact, but without revealing that data to everyone? The problem is that the Salary Info worksheet contains salary information for the entire organization, and this isn't information that should be shared with everyone.The Salary Info sheet might reveal, for instance, that a coworker is leaving in three months-the coworker has told management, but the employee isn't ready to tell the entire company just yet. (In my silly example, I just divided the total salary into four equal quarters.) Which leads to the problem: There's a worksheet called Salary Info that's used to populate the Salaries line in the workbook. The green areas are the portions that the users would fill out-probably not the department heads, but just someone in the department. A super-simplified and unrealistic input worksheet might look like this: Each department would have their own tab, showing their planned yearly budget by month for the coming year. My wife wants to create a budget spreadsheet for the various departments in her company to use. Still, the following should be considered as only a semi-safe solution. When I tested with my dummy salary worksheet, I could see individual salary values, but no actual text-so there wasn't any way to associate a salary with a person.

However, the Excel files are just zipped XML files, so it's possible to unzip them and open them with a text editor. Important note: Please see the comments-the method I discuss here is secure from casual users.