Macro button that does not pull data when protected

Hi, I have a macro button set up in excel that pulls data from different excel files and populates it in this sheet. I wanted useres to be able to hit that button and update the sheet with the information while protecting the headers and other formulas. When I use the protect function and lock all the headers and formula cells and hit the macro button it does not populate anything at all. It works fine when i have turned the protection off. Is there a way of protecting the sheet while using the macro to populate the cells? Thanks.