no the macro buttons are in an "overview" tab and the buttons take them to different sections of the "master Data" tab, i think the problem may be to do with autofilters as i am trying to reset all the autofilters at the beginning of each of the macros.