| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically apply a macro to all worksheets
for example, i create a simple macro for inserting a row above a certain cell. I want the macro applied to all sheets when running the macro. Does anyone know how to do this? thanks a lot! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=515021 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically apply a macro to all worksheets
see
http://www.mvps.org/dmcritchie/excel...htm#loopsheets --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "minrufeng" wrote in message ... for example, i create a simple macro for inserting a row above a certain cell. I want the macro applied to all sheets when running the macro. Does anyone know how to do this? thanks a lot! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=515021 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically apply a macro to all worksheets
However, if I misoperate a macro to all worksheets and want to undo this operation, what should I do? Thanks for your great help! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=515021 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically apply a macro to all worksheets
Save your workbook before you run this macro.
If you screw it up, then close that workbook without saving and reopen it. minrufeng wrote: However, if I misoperate a macro to all worksheets and want to undo this operation, what should I do? Thanks for your great help! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=515021 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
automatically apply a macro to all worksheets
try.
Sub insertrowinallsheets() myrow = ActiveCell.Row For Each ws In Worksheets ws.Rows(myrow).DELETE Next End Sub -- Don Guillett SalesAid Software "minrufeng" wrote in message ... However, if I misoperate a macro to all worksheets and want to undo this operation, what should I do? Thanks for your great help! -- minrufeng ------------------------------------------------------------------------ minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208 View this thread: http://www.excelforum.com/showthread...hreadid=515021 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro automatically on opening of worksheet | Excel Worksheet Functions | |||
| How do I automatically copy columns to/from Excel worksheets? | Excel Discussion (Misc queries) | |||
| Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
| make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
| Execute Macro automatically after hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
