Thread: Prevent Users from switching worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John M[_5_] John M[_5_] is offline
external usenet poster
  
Posts: 10
Default Prevent Users from switching worksheet
The following code will hide the worksheet tabs from the user. I do not know if this is sufficient to solve your proble

ActiveWindow.DisplayWorkbookTabs = False
Reply With QuoteReply With Quote