Lock/Protect Grouping Feature in Excel

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.
 
G

Gord Dibben

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
 
T

tracylhughes

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userinterfaceonly 5
Lock cells without protecting sheet? 2
how do I get excel to use tab to move in a sheet 2
Protection using the subtotal function 1
How to get the plus/minus at the top when grouping 3
grouping and ungrouping a protected sheet 0
Grouping 6
Lock spreadsheet but can sort 6

Top