I tried that method couple of times.But when I protect the sheet with a password.
It is showing a message "The cell or chart that you are trying to change is protected and terefore read only."
How 2 merge more than 1 excel file into a single file with sheet arranged alphabetically.
please give solution with examples (by using macros and without macros).