VBA in Excel (Split from "Excel forums?"

[Report_2]

What led me to inquire is a speadsheet I have downloaded off the net somewhere that I do not remember the source. There is no license agreement to it but I recall that the author didn't want it spread around.
It is a Keno game although that fact is irrelevant.

The game fills the viewable screen and contains no scroll bars.
The game uses macros or VBA/VBE to provide the payoffs.

1. How can the game or spreadsheet contain no scroll bars?
2. Where are the tables located that contain the payoff values?

Remove the attachment if it is a problem.

Obviously I need/want to learn about Excel and basic Visual Basic.

What I have read is way over my head.

I have been unable to find just the basics to understanding the use of VB in Excel.

I want to learn to improve my abilities at work and not just to play Keno.

Any leads, direction or advice would be appreciated.

[smurfy]

I'm heading away on a business trip for a few days but I've taken the file.

Once I've had a look I'll see how many of your Q's I can answer.

I know we have a few other VBA whiz's that frequent V Dr so somebody may get in before me.

Quick note though, turning off Scrollbars, worksheet tabs, toolbars etc is simple, use the macro recorder to record yourself turning them off (Tools>Options>View).
The values will be on a worksheet that has become inaccessible because there are no tabs visible.

[smurfy]

Ahh, it's from j-walk - Good resource there - I've picked up a lot of stuff from there.

It's actually a lot simpler and not locked down as I thought it may have been.

You can actually reinstate the scrollbars and tabs yourself by using the Tools>Options>View.

[Report_2]

Thank you.
Almost too easy.
I also was able to unprotect the payoffs so they are in tune with the local 'pay for' game.

Thanks