Edit in Browser defeats code

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?
Who is Participating?
add code to the workbook_Close event, hiding all the sensitive worksheets and save the workbook.
BigWill5112Author Commented:
duh!  Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.