Peo,
Before you send such a response, please check the full thread.
Bob's last email to me was the one which started being patronizing.
Bob, if anything, had started to complicate the issue by asking what was
shown.
Well it didnt take a lot of thought to realise that 'doesn't work' means it
was doing the same thing when I asked for assistance.
I work in IT and realise that exact details are important, however sometimes
you need to let common sense prevail and not over complicate things.
Anyway, I did exactly follow Bob's instructions, by both typing & cut &
pasting (but of course changing the worksheet to mine) the code into View
Code window but it did not work.
Don't want to dwell on this any longer so please consider this the last
communication.
Thanks for both Bob's & your time on this.
Regards
Ian
--
SomeHelp


"Peo Sjoblom" wrote:

'Doesn't work' tends to mean it is doing the same thing it was before
I asked for assistance

Really, thanks for letting us know what "Doesn't work" means

Ie, Opening on the same worksheet that I was on when I save the document.

However I've worked it out, and unfortunately you didn't tell me one
detail
that would have made your suggestion work. This was to change the
drop-down
menu from 'General' to 'Worksheet' in the VisualBasic (View code) window,
and
then paste the code.

If you had copied and pasted the code correctly, General would automatically
changed to Workbook meaning it is not necessary to first select Workbook
from the dropdown, so in fact Bob gave you correct information but you
either misunderstood or handled it incorrectly. The error was between the
chair and the PC.


Have a nice day!


--


Regards,


Peo Sjoblom



He told you to