row numbers missing etc

[Guest]

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

 

[keepITcool]

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 >

 

[Greg Wilson]

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.

 

[Guest]

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]

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!