Macro does not run. Pop up box appears headed 'Create Table'

For some reason the keyboard shortcut you assigned to your macro does not work for your friend. Thus, Excel reponds to the built-in shortcut control+L, which is to convert a range to a table (Home tab, format as table). I assume you copied your macro as text for your friend. This does not copy the keyboard short-cut with it, you have to set that up yourself. At your friends machine, open Excel and press alt+F8. Find your macro in that list and press Options. Now you can set-up the short-cut key.