Activate Non-Active Workbook from Code 1

[tbl]

I am looking for a way to activate a particular worksheet from a timer function. The problem I have is that I do not want to use the workbook name in my code (unprofessional). I know that I can use ActiveWorkbook.Name to identify my book, which works fine if that book is active at the time, but when using a timer, any book could be active if the user has changed to another workbook.

 

[xlbo]

do you want to activate the workbook that holds the code ??

If so, just use THISworkbook rather than ACTIVEworkbook

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[tbl]

Thanks Geoff, have a star on me !

Richard