yes, but the macro sets defined per profile are those set in the chat window/ctrl-m dialog, whereas using a ?loadmacro command on enter will use macros that have been saved with ?savemacro. if you load a profile's macro set, and then change any macros (even by ?loadmacro to get a whole new set) those changes will overwrite the saved copy of the macros. that's useful if you want to retain a macro the next time you visit an arena, but obviously can be very frustrating if you want to keep the original saved version.
i personally use ?loadmacro and ?savemacro exclusively, with a ?loadmacro among my auto entry commands.
another tip: change the macro definition keys to give you at least full range of the function keys (i use all 20 macro slots), and set one macro to be ?loadmacro <name>. this is very useful if you accidentally overwrite macros when a sentence or command is halftyped and you hit a macro key. of course, that can't be saved in game -- use the chat window editor and then ?savemacro the result, or edit the .mac file directly.
hope that helped