hi, im having multiple excel files in a folder which is password protected (same password for all files). I need a userform with 4 text box (textbox 1 = to input forlder name to be opened, textbox 2 = cell to find, e.g a1... textbox 3= to select sheet e.g Sheet 1 , textbox 4= to input formula e.g "=a1+a2+a3")
basically this userform will open all the excel files in the folder which was selected based on textbox 1, unprotect the sheet based on the input in text box 3 and find the cell based on textbox 2 and insert the formula based on textbox 4 then later protect the sheet back with same password and save the files. the mcaro need to loop to all excel files in the folder which selected based on textbox 1.
Hope some one can help on the vba code for this process.
Thank you.
basically this userform will open all the excel files in the folder which was selected based on textbox 1, unprotect the sheet based on the input in text box 3 and find the cell based on textbox 2 and insert the formula based on textbox 4 then later protect the sheet back with same password and save the files. the mcaro need to loop to all excel files in the folder which selected based on textbox 1.
Hope some one can help on the vba code for this process.
Thank you.