VBA Protection Problem w Grouping and Cell comments

[fmaa]

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:

Please Login or Register  to view this content.

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.

[fmaa]

bump. anyone?

[JasperD]

Hi fmaa,

as for your first issue - this is not really possible, unless using a workaround.
You could do the following as a Workbook "before right click" event.

Please Login or Register  to view this content.

However, you will ALWAYS get an inputbox popup to add a comment on right clicking a single cell. I hope this is workable for you.

Please click the * below if this helps

[JosephP]

userinterfaceonly protection does not save with the workbook-it must be reset on opening each time

[fmaa]

jasper, joseph, thank you much. I will update accordingly.