I have a workbook to be distributed to a bunch of people. I want it to mostly be protected/locked. However, some macros that are accessed by drop-down lists have to be able to hide columns and rows (using Custom Views for columns, and a key field for rows). Protecting it seems to break it. I haven't had time to play with it much, but any insight is appreciated.

If you see anything else that would make it more robust, I'd really appreciate it: it sometimes crashes in some obscure way where enableevents and ScreenUpdating are both left off, and maybe other problems. It needs to be pretty tough, ideally.

Thanks!

Keith