I had a VBA Function Code that keeps running when I run other Modules or Userforms, or when I click on other cells in the spreadsheet. This causes the function to randomly generate QR codes on the spreadsheet when I don't want them to. I've changed my calculations to "Manual" and not the default "Auto" but am still having the same issue.
Here is the VBA Code for the function that generates QR codes.
Function QR_Generator(qrcodes_values As String)
Application.EnableEvents = False
Dim Site_URL As String
Dim Cell_Values As Range
Dim k As Range
Set Cell_Values = Application.Caller
Site_URL = "https://chart.googleapis.com/chart?chs=90x90&&cht=qr&chl=" & qrcodes_values
On Error Resume Next
ActiveSheet.Pictures("Generated_QR_CODES_" & Cell_Values.Address(True, True)).Delete
On Error GoTo 0
.Name = "Generated_QR_CODES_" & Cell_Values.Address(True, False)
.Left = Cell_Values.Left + 2
.Top = Cell_Values.Top + 2
.Right = Cell_Values.Right + 2
.Bottom = Cell_Values.Bottom + 1
QR_Generator = ""
Application.EnableEvents = True