Hi All, Please help me out in putting restriction in my macro file. this file has been created to consolidated data from differnt files have same format of data. A designated path of data folder has been given in the macro. I am getting a dialogue box to select the data folder from which we required to consolidate the data and that dialoge box is opening with the designated path only. Now I want to restrict this dialoge box in a way that no boday can manually change the path of the data folder.