| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock/Protect Grouping Feature in Excel
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock/Protect Grouping Feature in Excel
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 On Thu, 1 Oct 2009 08:32:01 -0700, tracylhughes wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock/Protect Grouping Feature in Excel
Thanks Gord!
"Gord Dibben" wrote: 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 On Thu, 1 Oct 2009 08:32:01 -0700, tracylhughes wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock/Protect Grouping Feature in Excel
Of course I meant "hide the Sheet Tabs from view"
Gord On Thu, 1 Oct 2009 10:39:07 -0700, tracylhughes wrote: Thanks Gord! "Gord Dibben" wrote: 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 On Thu, 1 Oct 2009 08:32:01 -0700, tracylhughes wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock/Protect Grouping Feature in Excel
Understood. Thanks again.
"Gord Dibben" wrote: Of course I meant "hide the Sheet Tabs from view" Gord On Thu, 1 Oct 2009 10:39:07 -0700, tracylhughes wrote: Thanks Gord! "Gord Dibben" wrote: 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 On Thu, 1 Oct 2009 08:32:01 -0700, tracylhughes wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel lock / Notify feature malfunctioning | Excel Worksheet Functions | |||
| Excel lock / Notify feature malfunctioning | Excel Worksheet Functions | |||
| protect excel wrkst but still be able to use grouping and lists | Excel Worksheet Functions | |||
| Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
| comment indicators should feature lock or pw protect limiting acc. | Excel Worksheet Functions | |||
Linear Mode
