Hi Teylyn,
Apologies for the coding. I am new to this forum and its rules.
I have put your code in the "ThisWorkbook module" but when i open it the "unprotect sheet" dialog box appears.
I have a password set therefore why i thought i needed to include the code relating to "protect password".
I have attached your initial file but now with a password assigned "aaa". It provides the same issue i am having in my example.
Suggestions please?
If i do not protect my sheet, the outlining works fine however i need my spreadsheet to be protected for use by various parties.
Thanks again Teylyn.
Bookmarks