ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting formulae while still using expand and minimise data gro (https://www.excelbanter.com/excel-discussion-misc-queries/125693-protecting-formulae-while-still-using-expand-minimise-data-gro.html)

DannyS

Protecting formulae while still using expand and minimise data gro
 
I have a sheet that has data groups (Data | Group and Outline | Group) that
are used to minimise and maximise the rows shown. I want to protect some
rows from edit, but when I do so the user can no longer use the + and - signs
by the rows that can be expanded.

Is there any way of protecting cells without disabling the maximise/minimise
available via data grouping?

I can provide an example spreadsheet if it helps?

Thanks very much in advance for any help, Dan


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com