Formating

Mar 11th, 2002, 07:21 AM

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 · Mar 11th, 2002, 08:02 AM

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.

Mar 11th, 2002, 08:10 AM

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 · Mar 11th, 2002, 09:02 AM

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 ]

Mar 11th, 2002, 09:02 AM	#4
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 07:21 AM	#1
Guest Posts: n/a	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

Mar 11th, 2002, 08:02 AM	#2
Bruno Board Regular Join Date: Feb 2002 Posts: 468	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.

Mar 11th, 2002, 08:10 AM	#3
Guest Posts: n/a	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