Unfortunately, without look at the VBA code, I wont be able to comment on whether you can convert it to an addin or not. However, even if much of the code can be "copied and pasted" into a new addin, you will still have to do a bit of additional programming in order to get the code to work as an addin.