Hi, how can i enable the Outline Show/Hide Detail when the sheet is protected.
I have a financial summary that is fairly long and need this option but dont want anyone touching the formulas.
Thank you.
Hi, how can i enable the Outline Show/Hide Detail when the sheet is protected.
I have a financial summary that is fairly long and need this option but dont want anyone touching the formulas.
Thank you.
https://www.excelforum.com/showthread.php?t=360672
You will need to add an explicit subroutine to VBA to circumnavigate the restrictions on protection.
This code will allow you to protect the workbook while retaining the function of changing the outline.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks