Hiding Worksheet tabs with VBA code(#2)

[Guest]

I'm looking at an application containing VBA code. The workbook opens with a spreadsheet. There are no screentabs at the bottom. There is no such code as you describe ----

ActiveWindow.DisplayWorkbookTabs = Fals
o
Worksheets("tab").Visible = Fals

Is there another way this application may be hiding the tabs. It is using some protect code such a
ActiveSheet.Protec

Any thoughts on thi

Thanks

Ca

 

[Frank Kabel]

Hi
maybe just a manual setting in 'Tools - Options - View'
Have you also checked the workbook module?

--
Regards
Frank Kabel
Frankfurt, Germany

I'm looking at an application containing VBA code. The workbook

opens with a spreadsheet. There are no screentabs at the bottom.
There is no such code as you describe ----

ActiveWindow.DisplayWorkbookTabs = False
or
Worksheets("tab").Visible = False


Is there another way this application may be hiding the tabs. It is

using some protect code such as