Hi,

I have one master excel file and 56 another files, In master file there is one user form with buttons to open each 56 files. And in each 56 files there are 3 buttons, Back, Protect & Unprotect. Where on clicking of Back button it closes the current file & opens Master file. Protect button protects the curren book & unprotect button unprotects curren book. I have written macro for Back, Protect & Unprotect button in Master file.

Now I want to assign Macro in master file to Buttons in another file, where the Master file path is not fixed.

Can anyone please help me to solve this issue.