I have a sheet that I have password protected and I really want to keep it this way but it won't let anyone hide or unhide rows or columns. It completely freezes up for a couple minutes if you try. This only happens in excel 2010; it doesn't happen if someone opens in 2003. I found keyboard shortcuts work for hiding and unhiding rows but not columns- ugh.
When I password protected I checked all the boxes so the only thing protection should be doing is stopping them from modifying the locked cells so I don't know why I'm having this problem.
Can anyone help?
Thanks!
When I password protected I checked all the boxes so the only thing protection should be doing is stopping them from modifying the locked cells so I don't know why I'm having this problem.
Can anyone help?
Thanks!