C Cammandk Member Jun 6, 2013 #1 I want the tabs to be hidden in the workbook. I've turned off in advanced option and it works for a while but then they come back. I am using macro's to go to different sheets within the workbook. Any ideas.
I want the tabs to be hidden in the workbook. I've turned off in advanced option and it works for a while but then they come back. I am using macro's to go to different sheets within the workbook. Any ideas.
Luke M Excel Ninja Staff member Jun 6, 2013 #2 First, double check the code within your macro to make sure you aren't turning them back on from in there. Would be a line like this Code: ActiveWindow.DisplayWorkbookTabs = True
First, double check the code within your macro to make sure you aren't turning them back on from in there. Would be a line like this Code: ActiveWindow.DisplayWorkbookTabs = True