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

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

The missing row numbers and worksheet tabs are probably
just standard Option settings from the Tools menu. Once
selected, they remain as such until changed and don't
required code. If I'm correct on this, you need to select
Tools|Options|View tab. Then check the check boxes:
"Row & column headers" and "Sheet tabs". You may also want
to check "Vertical scroll bar" and "Horizontal scroll bar".

If the Worksheet Menu Bar is hidden then run the code:
Sub UnhideMenu
Application.CommandBars(1).Enabled = True
End Sub

Regards,
Greg

-----Original Message-----
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
.

Thanks all.
@Greg Wilson - interestingly, it was option settings - but it is the workbook itself that seems to disable these. How is that possible when macro's are disabled ?? With all other workbooks etc all the tabs etc are shown - only this workbook that disables them.
Ironically, I am not allowed to share the workbook to help everyone to analyse it further, yet can't use it otherwise ! Corporate logic ;)
Many thanks

"Greg Wilson" wrote:

The missing row numbers and worksheet tabs are probably
just standard Option settings from the Tools menu. Once
selected, they remain as such until changed and don't
required code. If I'm correct on this, you need to select
Tools|Options|View tab. Then check the check boxes:
"Row & column headers" and "Sheet tabs". You may also want
to check "Vertical scroll bar" and "Horizontal scroll bar".

If the Worksheet Menu Bar is hidden then run the code:
Sub UnhideMenu
Application.CommandBars(1).Enabled = True
End Sub

Regards,
Greg

-----Original Message-----
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
.

So are you saying that if you do the below list of actions that the
settings are still changed?

1) Open the workbook with macros disabled
2) Correct the Option settings
3) Close the workbook
4) Reopen the workbook again with macros disabled

Regards,
Greg


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!