Hi,
Thank you fort he reply. The first hundred lines of opening all the sheets is crucial because I dont know which sheets a user has open prior to running the macro. Simply all the macro does is open all pages then close all pages except for the ones that satisfy the configuration the user chooses. I am unable to share a work book because of sensitive information in my model. I can not take the sensitive info out because it the issue will not occur otherwise. If there is any more info I can provide to help with this please let me know than you so much.