Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Leon Hansen on Dec 14 In MS Office Category.

Simple Macro to Format All Sheets in a Workbook?

Question Answered By: Helene Stewart on Dec 14

This should do it

Option Explicit

Sub formatSheets()

Dim x
Dim y

x = Worksheets.Count

While x > 1

Worksheets(x).Activate
Format1
doevents
x = x - 1
Wend
Application.Worksheets(x).Activate
format2

End Sub

This Question has 7 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Simple Macro to Format All Sheets in a Workbook? Or get search suggestion and latest updates.

Related Topics:

reconcile data from samew workbook but in different sheet
MOVING SHEETS BETWEEN WORKBOOKS
Max number of sheets in workbook?
Sharing Macro/workbook with others
My Personal Macro Workbook Won't Show
Copy, then email workbook without macro attached
macro to get info from workbook thats name changes
Protected sheets and Macro Runing Problems
Sort macro to display on a different sheet
make a secure protected sheet with macro
hyperlink to a VBA macro, on an Excel sheet
Macro to Perform Same Function Only on Certain Sheets
Run a macro on multiple sheets
Runnning a macro automatically after the sheet loads
Need Help for Macro to Perform Same Function Only on Certain Sheets
Copy Sheet and Macro Error
Delete VB/Macro Sheet
Change Workbook's Name
Making a Workbook as an Active Workbook without opening it
Prob running workbook activate code when workbook is opened by anot

Tagged:simple macro to format all sheets in workbook

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us