Prev: Excel Jululian
Next: what is short cut key for running the macros
From: joel on 24 Apr 2010 06:06

I would need to see the macro(s). Usually these problems are due to the
focus being on the wrong workbook or worksheet while the macro is
running. Replacing in the macro Activeworkbook with Thisworkbook will
help and specifying in the macro(s) the actual sheet names instead of
Activesheet.

The focus is changed when the following options are performed and can
cause problems inside macros

1) Open a workbook
2) Adding a new workbook
3) Adding a new worksheet.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=198129

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Excel Jululian
Next: what is short cut key for running the macros