I have been successfully using a macro that I learned here a few years ago but it stopped working. It doesn't show up in Macros anymore and I can't open the editor by using Alt+F11. When I try, it says out of memory.
Now, this is affecting every Excel workbook I am in--which do not have their own Macros. An error pops up in the other workbooks that says Can't find project or library (Visual Basic for Applications) after I hit okay, a dialog box called "References-VBA Project" pops up.
This is my macro: (to print a page # on each sheet)
<tbody>
</tbody>
Anyone have any ideas to help? I am not a proficient Macro user but was so happy to learn from everyone here and help out with a weekly chore by way of a macro. Thanks !
Now, this is affecting every Excel workbook I am in--which do not have their own Macros. An error pops up in the other workbooks that says Can't find project or library (Visual Basic for Applications) after I hit okay, a dialog box called "References-VBA Project" pops up.
This is my macro: (to print a page # on each sheet)
| Sub PgNumbs() |
| For i = 1 To 50 |
| With Sheets("WorkOrders") |
| .PageSetup.RightHeader = "Page " & i |
| .PageSetup.FitToPagesWide = 1 |
| .PageSetup.FitToPagesTall = 1 |
| .PrintOut Copies:=1 |
| End With |
| Next |
| end sub |
<tbody>
</tbody>
Anyone have any ideas to help? I am not a proficient Macro user but was so happy to learn from everyone here and help out with a weekly chore by way of a macro. Thanks !
