Prevent Cycling Between Tabs

I am working on a multiple tab report that uses VBA code to control which users see each tabs and to update the data every hour. The problem I am facing is when the data is refreshing, all of the tabs become unhidden and are cycled through which could result in data being seen by an unauthorized person. Is there any way to prevent the tabs from cycling or a better solution for handling user security?


Please sign in to leave a comment.