continue work on macro

modified so that we catch system error for macros, modified method to call formula (which is SP) instead of trying to figure out what user is trying to do