Option Explicit causing compile error

[john316swan]

This code is periodically crashing excel when a user doesn't save a workbook.

Sub FillLog(uName)
Option Explicit
uName = Environ("UserName")


Sheets("Values").Cells(10, 43) = uName


End Sub

I ran the "Compile VBA Project" from the debug menu and it gave me an error or "invalid inside procedure" so I figured I messed up and needed to add the Option Explicit above the sub FillLog(uName)...The problem is, that it is in hundreds of workbooks Any advice on how to fix this?

 

[DanteAmor]

try this:

Option Explicit


Sub FillLog(uName)
    uName = Environ("UserName")
    Sheets("Values").Cells(10, 43) = uName
End Sub


Sub test()
    Dim uName As String
    Call FillLog(uName)
End Sub

 

[john316swan]

Is there a way to write a macro to delete a specific macro upon workbook opening that can be saved in a personal macro workbook?

 

[DanteAmor]

Is there a way to write a macro to delete a specific macro upon workbook opening that can be saved in a personal macro workbook?

To remove a module:

Sub Remove_Module()
    Workbooks("other.xlsm").VBProject.VBComponents.Remove Workbooks("other.xlsm").VBProject.VBComponents("Module1")
End Sub