I am having a few issues with a workbook. The first one should be easy but I am having an issue getting it working.
First, I am trying to allow comments on any cell, some of which may or may not be intentionally protected. I haven't been able to find anything via search and am not really sure how to implement this.
Second, I want to allow grouping of certain predetermined column sets. I have the following code within an iteration of all sheets that are not very hidden:
ThisWorkbook.Sheets(i).Protect Password:="test", DrawingObjects:=True, Contents:=True, Scenarios:=True, UserInterfaceOnly:=True
ThisWorkbook.Sheets(i).EnableOutlining = True
ThisWorkbook.Sheets(i).EnableSelection = xlNoRestrictions
It works fine but after you save and close it doesn't allow grouping and ungrouping anymore. I am pretty baffled as to why it works initially but not after reopening the file... I am hoping I have made a stupid mistake.
Thanks.
Bookmarks