Sheet Selection VBA Code is not working properly

[robrobet]

I found this workbook from internet, I like the way it created but only this some of the macro are not work and show error. I know on this site lots of member that may able to help to get this going. Problem is when you click on account rec or payable it does not work. please help me to get this sheet work. please see attached sheet.
I have to do in zip file because it is bigger file sorry to create extra step to get a file.

Thanks a lot in advance all of you
RR

[:) Sixthsense :)]

It's working fine for me

Tested in 2003 & 2010 version of excel.

[robrobet]

Did you try Click accounts payable and account receivable, there is the problem

[:) Sixthsense :)]

When I click both then it moves to the respective sheet nicely

[robrobet]

Vert strange, look at the attach pictures please one i open the workbbok and second when i click on account rec or payable

[:) Sixthsense :)]

Press Alt+F11 to get the VBA window.

Tools>>References>>Check whether it is showing any MISSING references. If so tick it and give ok and check

[robrobet]

There is hundred of avilable references, not sure which one to tick. nothing showing missing references

[robrobet]

I try on 2007 and 2003 version, not working on my computer. all the oother macro work fine for balace sheet , income sheet and rest but onlt the account rec and payable is not working.

I try on 2 different computers,

[:) Sixthsense :)]

@ robrobet,

Please rename the thread title something like "Sheet Selection VBA Code is not working properly"

[robrobet]

Change it as you said.
Thanks

[:) Sixthsense :)]

@ robrobet,

Thanks for changing the thread title

[:) Sixthsense :)]

I am sure it is missing the references.

Can you please share the screen shot of the references?

[robrobet]

There are lots of them not sure how I will fit all in screen shot because it open in little window and I need to scroll down to view them all, is their special one i need to tick.

[robrobet]

Bumped up, please suggest why it is not working for me

[JOHN H. DAVIS]

As a minimum are these checked?

Please Login or Register  to view this content.

[robrobet]

Hi John,
It was just my computer, worked fine now.
Last request how I can unhide all the sheet if I want to see them and how I can I hide these again as they are now.
Thaks a lot in advance
RR

[robrobet]

Hi John,

Thanks for help, It was my computer problem.
Can you help mw how I can unhide all the sheet or hide them as they are now.
Thanks in advance for your time
RR