G
Guest
Hi,
Just a quick query. I have a 60 odd sheet excel sheet with individual
passwords on each sheet, that need changing, each password is the same on
each sheet. Is there a way to change all the passwords at once. Or will
password protecting the whole workbook after unprotecting do that same job.
Each sheet has locked and unlocked cells so only people who know the password
can change the locked sections.
Thanks in advance for any help offered.
Cheers
tom
Just a quick query. I have a 60 odd sheet excel sheet with individual
passwords on each sheet, that need changing, each password is the same on
each sheet. Is there a way to change all the passwords at once. Or will
password protecting the whole workbook after unprotecting do that same job.
Each sheet has locked and unlocked cells so only people who know the password
can change the locked sections.
Thanks in advance for any help offered.
Cheers
tom