Lock/Protect Grouping Feature in Excel

  • Thread starter Thread starter tracylhughes
  • Start date Start date
T

tracylhughes

I have an Excel file with several spreadsheets that are updated simulateously
using Excel's grouping feature. The problem is that this file is updated by
many different people. Someone will click on a tab at the bottom and
accidentally ungroup it. Is it possible to *lock* the grouping feature?
Thanks.
 
Sounds like a very dangerous method of updating across worksheets.

All I can think of is to hide the Sheets from view so thatt specific
accident doesn't happen.

I can think of many more accidents that could occur<g>


Gord Dibben MS Excel MVP
 
Thanks Gord!

Gord Dibben said:
Sounds like a very dangerous method of updating across worksheets.

All I can think of is to hide the Sheets from view so thatt specific
accident doesn't happen.

I can think of many more accidents that could occur<g>


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top