Formating

G

Guest

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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top