Hi
I have each User wise excel files i want to control each files from my System.
control like
1) prior to current date each sheets are password protect so if i want to unlock then from my system i want to do that no need to go to that user & unlock
why i need this because if user close that file & i can open & unlock that after closing that again lock the sheet so i need this kind of any macro
Please tell me how to do this
I have each User wise excel files i want to control each files from my System.
control like
1) prior to current date each sheets are password protect so if i want to unlock then from my system i want to do that no need to go to that user & unlock
why i need this because if user close that file & i can open & unlock that after closing that again lock the sheet so i need this kind of any macro
Please tell me how to do this