Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formating

  1. #1
    Guest

    Default

    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

  2. #2
    Board Regular Bruno's Avatar
    Join Date
    Feb 2002
    Location
    Flanders
    Posts
    484
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  3. #3
    Guest

    Default

    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

  4. #4
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •