Originally Posted by
lucas
I think the most widely advised method of working around this problem is to create an addin.
An alternative is what I usually do: I add this to the workbook open code(note that you will have to change the path to suit your needs). Then the user is working with a copy of the file and the original doesn't change.
[vba]
Private Sub Workbook_Open()
ActiveWorkbook.SaveAs FileName:="F:\Temp\BOM.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Application.Run "checkname"
End Sub
[/vba] Note: you may wish to put your code to remove formula's etc. in something besides workbook open. beforeprint maybe.....hope this helps