how to protect excel worksheet and still use the outline buttons?
 

Hi,
I have this problem, when I password protect the worksheet, I could no
longer use the outline / subtotal buttons at the top left-hand corner.

I know that we could select from the list the functions that we allow users
to perform while we still password protect the sheet e.g. format cells, use
auto-filter etc... But there's no such selection for users to use subtotal /
outline buttons.

Anyone has any solution to this?

Thanks!