Hi Everyone,
I'm having an issue on occasion where macros that are written in the vba editor are not showing up
in the macro ribbon so I can assign it to a button? Whats strange to me is the exact same macro
will show just fine in a different workbook? It is a macro enabled workbook and I have a couple of
other macros that show in the ribbon and run just fine?
Thanks!
I'm having an issue on occasion where macros that are written in the vba editor are not showing up
in the macro ribbon so I can assign it to a button? Whats strange to me is the exact same macro
will show just fine in a different workbook? It is a macro enabled workbook and I have a couple of
other macros that show in the ribbon and run just fine?
Thanks!
Code:
Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.SaveAs FileName:="C:\OFFICEELITE\PLU.XLSM"
ActiveWorkbook.Close
Application.Quit
End Sub