mail it to address below.. and I'll see what I can do.
I'll be here for another hour max.

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?TWlrZQ==?=" wrote:

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