[Last Call] Learn how to a build a cloud-first strategyRegister Now


Edit in Browser defeats code

Posted on 2012-09-07
Medium Priority
Last Modified: 2012-09-10
Have a spreadsheet that I store on SharePoint that hides and unhides certain tabs for managers according to their logon ID because of salary info contained in them.  open in browser has now been enabled on sharpoint.  People choosing to do so are getting an error message and then the spreadsheet opens anywya without any code running and displaying the workbook according to how the previous manager openend it allowing the one manager to see another manager's salary info.  is there a way to fix this?
Question by:BigWill5112
LVL 46

Accepted Solution

aikimark earned 2000 total points
ID: 38379213
add code to the workbook_Close event, hiding all the sensitive worksheets and save the workbook.

Author Comment

ID: 38382804
duh!  Thanks!

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

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

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

830 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