Hi Maagaard - To find an existing macro, simply open all workbooks that have the .xlsm extension. Those are the ones that can contain macros. Then press Alt + F11 to open the VBA editor. The macros will be listed. Once you find the macro, we can work on the rewrite as necessary.
Hope this helps.
Happy Excelling,
goesr