I will answer longer later on rest of this message, but creating the textbox
hyperlinks is easy
Just create a textbox from the draw menu and put the desired text in it.
then right-click it and one of the items on the menu that drops down is
hyperlink. Select that and in the "insert hyperlink" dialogue box that
opens, click icon on middle left that says "place in this document" Then in
the box in the middle, you will see the tabs of the page listed. Just click
on the desired tab you want the textbox to link to and click ok. Note that
when you click on the tab, the cell reference in box above that comes in at
A1 automatically, but you can make it go anywhere on the sheet by typing in
any cell reference.
Ross

Ken Johnson" wrote in message
oups.com...
Ross,
CV = Curriculum Vitae, which is a document outlining your,
qualifications, abilities, achievements etc. You submit your CV to a
prospective employer and if they like what they read you're one step
closer to getting the job, otherwise you're culled out. I've never had
to put one together but my son Eric had to for a job in a carwash cafe,
making coffees and serving food to customers while their car is being
washed and polished. He got the job and he's there right now. My
daughter also had to submit one for her casual job (mainly cashier
work) at Target, a Chain of Department stores. Target is pretty
down-market so everybody jokingly pronounces it Tar-shay to improve its
image.
CV's are a recent phenomenon. I applied for my first job (apprentice
photoengraver-etcher) in 1966 and got the job because I could write my
name. Technological change put an end to that job. After just 2 years
of a 4 year apprenticeship the number of workers had halved. My job
served the letterpress printing industry which was losing work to the
lithographic printing industry. I could see no future in my job so I
completed school at night while completing the apprenticeship by day. I
then went through Uni with the support of a Teachers' Scholarship. I
was actually paid to go to Uni (We baby boomers had it so easy. I feel
sorry for my kids, without parental support they're stuffed).
It's funny you should ask me about seeing kankaroos etc out the window.
It's a long standing joke that Americans think that kangaroos hop down
George St (the main street of Sydney). About 18 years ago I was
teaching at Pit****er High School Mona Vale. Mona Vale is a beachside
suburb in Sydney's north and about a 30 min drive from where I live (68
William St Roseville Sydney, one of the northern suburbs). The school
has a sister school in USA, I think it's called New Trier High, but I
forget where it's located. A visit was organised and we had the company
off a New Trier High science teacher and some students for a couple of
weeks. One morning, during that two week visit, as I was driving to
school a wallaby hopped across the road in front of me. (the road
passes through a National Park). This was a unique experience for me,
and some Americans returned home from Australia knowing that kangaroos
on George St is not all that far from the truth.
I've had a look at your songbook. How do you set up those textboxes
with hyperlinks on the menu sheet? I'd like to know how to do that, it
looks useful.
Could you put one of your song word docs on your site? Word is
controlled by its version of VBA, I've used it a little bit and I might
be able to do something about the problem you explained (could take a
while though). I'm keen to manipulate Word through Excel's VBA. It
involves using references, of which I know very little, and this looks
like an opportunity for me to get started on a new VBA skill.
I haven't yet looked at that Google Planet Earth thingy (what ever it's
called), I clicked on the Preview button to review what I've typed then
when I returned to edit I can no longer refer to your messages. I'm
scared I'll lose everything if I fiddle around trying to get back to
your messages, it's happened to me before.
I too play guitar by ear. The only time I read music is when I play
cornet, which is never these days. I used to do things like play a 45
rpm record at
33 1/3 to slow down fast riffs (still couldn't play some of them) or 78
rpm to raise the pitch and audibility of bass lines, but that was a
long time ago.
I don't have perfect pitch but I have been able to work out some of
John Scofield's weird chords. A music teacher once asked me to work out
the chords off a tape recording and she was pleased with the result. My
daughter plays the trumpet and has done quite well. She's up to grade
whatever(I've lost count). She's wearing braces at the moment, and they
have held her back a bit. They come off sometime next year. She's
studying music for her Higher School Certificate and sometimes hints at
becoming a high school music teacher. I try to steer her away from that
idea. We Australian teachers are constantly having to go on strike to
improve our pay and conditions but we always seem to be going
backwards. When I started teaching in 1977 our pay was equivalent to
that of a politician on the back benches, who are now way ahead of
teachers.
Getting back to the songbuilder: Please don't take offence (We need
them to keep in the kangaroos) but I'm not happy with the chords for I
Will. I've played them and, to me, something sounds wrong. You can call
me a pedant, I won't mind, but my preferred chord sequence for I Will
is A, F#m, Bm, E, A, F#m, C#m (we differ here), A, D, E, F#m, A, D, E,
A, A7, D, E, F#m, D, E, A, D, E, F#m, B, E. I'm just using my ear here,
I haven't bothered to listen to the track or look up the music and
there are, from memory, a couple of spots in the song where there are a
some strong and fast chord changes that I have missed out. Try out my
chords and let me know what you think. Do you sing when you play? When
I was in the Bush/Rock band in Finley I sang a few songs to give our
singer the odd break, and the only thing I had thrown at me was a pair
of panties (obviously done as a joke by a friend in the audience).
Bye for now, I've got some marking I must get done these holidays and
time is slipping away.
Ken Johnson