Formating

[Guest]

I need to edit about 50 workbooks to the same format. So I am just wondering is there a quick way to do that?
All I can think of right now is to copy all the sheets from all the workbooks to one workbook and select all the sheets in that workbook and then edit. But the copying sheets process is very slow
Thanks in advance

 

[Bruno_x]

I you have to make the same changes to all the sheets, you could record the changes in the first sheet and use this macro to make the changes in the other sheets.

 

[Guest]

Can a macro run on all selected sheets at the same time?
Because I have one macro and I tried to run it on all the selected sheets at the same time, it can only run on activated sheet but not all the selected sheets.
So, is there a code that I have to add to do it?
Thanks in advance

 

[Von Pookie]

You could try the following:

• Right-click any worksheet tab.
• Choose "Select All Sheets" from the menu.
• Make your selection on the active worksheet and apply your formatting.

_________________
"What am I, a magnet for these idiots?"
--Pearl Forrester, MST3K
This message was edited by Von Pookie on 2002-03-11 08:03