Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply macros to entire workbook
I would like to know how to apply a macro to an entire workbook. I created a
macro within a worksheet. I would like to apply it to every sheet without having to go each sheet and run the macro. Is there an easy way of doing this? I am not a programmer... Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply macros to entire workbook
Post your code.
A macro usually in placed into a General Module. Event code will be placed in a worksheet or Thisworkbook module. Do you mean you want a macro like this which works on all sheets in the workbook when you run it once? Sub Path_All_Sheets() Set wkbktodo = ActiveWorkbook For Each ws In wkbktodo.Worksheets ws.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & Chr(13) _ & Application.UserName & " " & Date Next End Sub Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 20:03:00 -0800, Sherry wrote: I would like to know how to apply a macro to an entire workbook. I created a macro within a worksheet. I would like to apply it to every sheet without having to go each sheet and run the macro. Is there an easy way of doing this? I am not a programmer... Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply macros to entire workbook
hi
if it's a sheet macro..no. the code has to be in a standard module or a this workbook module for you to apply it to the entire work book. post your code. Regards FSt1 "Sherry" wrote: I would like to know how to apply a macro to an entire workbook. I created a macro within a worksheet. I would like to apply it to every sheet without having to go each sheet and run the macro. Is there an easy way of doing this? I am not a programmer... Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I apply formula to entire column | Excel Discussion (Misc queries) | |||
HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW? | Excel Worksheet Functions | |||
How to apply a format to an entire workbook | Excel Worksheet Functions | |||
How to apply a format to an entire workbook | Excel Worksheet Functions | |||
I would like to apply the same calculation to an entire row | Excel Worksheet Functions |