Hi all,

I have inherited a workbook at work that was developed by an IT consultancy that are no longer contactable. When the workbook opens, it has VBA code that hides many toolbars etc. The worksheet tabs are also absent, and it creates a re-defined left-right scrolling area sparing the first 3 columns. In addition, the ROW number column on the left has vanished ie you cannot click on the row number to highlight the row etc.
When i open the workbook with macro security on "medium" - and deisable the use of macro's, the majority of these changes still occur - including the ROWS / absent worksheet tabs etc.
This comes as a bit of a puzzle to me - as it seems that there is code embedded within the worksheet which is still executed despite the security settings.
Interestingly, the workbbook has no file-open password, nor does the VBA code have a password. However, in teh VBA editor, "ThisWorkbook" DOES seem to have a password.
I really need to understand what exactly is happening here if posssible, and any means to actually get to edit this thing.
The VBA code itself is mainly just butotn code to switch sheets or filter columns uniquely.

Any help would be greatly appreciated