multiple workbooks
 

How do I perform the same group of keystrokes to multiple workbooks.
--
Libby

multiple workbooks
 

You don't. While it is possible to group multiple sheets within a workbook to
perform actions on, it is not possible to group multiple workbooks for the
same purpose (To the best of my knowledge)...
--
HTH...

Jim Thomlinson


"Libby" wrote:

How do I perform the same group of keystrokes to multiple workbooks.
--
Libby

multiple workbooks
 

can I open the multiple workbooks and perform a function on all of them
--
Libby


"Jim Thomlinson" wrote:

You don't. While it is possible to group multiple sheets within a workbook to
perform actions on, it is not possible to group multiple workbooks for the
same purpose (To the best of my knowledge)...
--
HTH...

Jim Thomlinson


"Libby" wrote:

How do I perform the same group of keystrokes to multiple workbooks.
--
Libby

multiple workbooks
 

Nope... You can only deal with 1 workbook at a time.
--
HTH...

Jim Thomlinson


"Libby" wrote:

can I open the multiple workbooks and perform a function on all of them
--
Libby


"Jim Thomlinson" wrote:

You don't. While it is possible to group multiple sheets within a workbook to
perform actions on, it is not possible to group multiple workbooks for the
same purpose (To the best of my knowledge)...
--
HTH...

Jim Thomlinson


"Libby" wrote:

How do I perform the same group of keystrokes to multiple workbooks.
--
Libby

multiple workbooks
 

"Jim Thomlinson" wrote...
Nope... You can only deal with 1 workbook at a time.
....

But you could apply the same operations to each file in sequence.

For Each wb In Workbooks
'do whatever with wb
Next s