| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros on excel
"stevebriz" wrote: You can do it through VBA open the workbook press "ALT" F11" this opens the VB editor will open Under the project explorer. double click on "this workbook " and then in the code window paste as below ...you need to replace NameOfMacro with your Macro name go back to excel and save the workbook. And next time you open it - it will ask to enable macros ...so say Enable and then the macro will run. Private Sub Workbook_Activate() Call NameOfMacro End Sub AJPG wrote: I'am sorry but i like to know how can activate a macro when i open a worksheet. I have done a macro (ctrl+a) that do wat i want, but i must run it when i open the worksheet. Thanks in advance Pinto Guimaraes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to remove excel macros still there after normal delete? | Excel Discussion (Misc queries) | |||
| I deleted all macros in Excel but still get dialog box | Excel Discussion (Misc queries) | |||
| Are macros created in Excel 2003 compatible with Excel 5.0/95? | Excel Discussion (Misc queries) | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Threaded Mode
