selecting open workbooks with VBA in Excel

[Big Chris]

Hello!

Thanks for at least looking at my request....

I have a workbook and I have recorded a macro to copy a sheet to a new
workbook and then paste the values to get rid of all the formulae.
I then want to return to the original workbook to make further changes
with the same macro. Problem is, the original worksheet may not have
been saved under a common name. It there a way with VBA to reselect the
original sheet regardless of its name?

Everything works fine with a known workbook name specified in the
macro.

Additionally: The help I can get from this fantastic forum is great,
but it's still way above my skill level. Can anyone recommend a
beginners VBA/Excel website where I might get real 'back to basics'
stuff such as using combo boxes and check boxes in a userform?

Many thanks,

 

[Jonathan West]

Hi Chris,

This group deals with VBA in Word. The Excel experts can be found at
microsoft.public.excel.programming. You will have a better chance of an
informed reply if you re-post there.

--
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com