Forum Discussion
excel sheet protect using password ?
I'm not certain this is possible. What I am certain of is this is not a good idea. Whilst Excel password protection has improved over the years, I don't consider it secure enough for handling anything sensitive.
If there's any way you can redesign your process so that the same file / workbook is not being passed between people who should not have access to data from any other participants, you should go that route.
Otherwise, you will perhaps encounter someone like me who will generally poke and prod at something like a protected workbook to find out what is being hidden. Last time I looked, which was more than 2 years ago, there were either 'instant crack' tools to remove Excel workbook protections or GPU accelerated tools for password guessing.
I hope someone can contradict me and make some assurances regards Excel security in the latest version.