| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group/Ungroup Protected Sheets
Hi,
Do you know a simple way to have the Group/Ungroup funtion to work even if the worksheet is protected? I use Office 2000 Thank you Alex |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Group/Ungroup Protected Sheets
Hi ive been told that its not possible to protect/unprotect a group yo
have to have the protection loop through each sheet! Like this..... For Each sh In ActiveWorkbook.Worksheets sh.Unprotect Next Put this statement after your Sheets Array selection. Hope this helps! Simo -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| group/ungroup protected sheets? | Excel Worksheet Functions | |||
| How can I allow group ungroup while sheet is protected? | Excel Discussion (Misc queries) | |||
| Group/Ungroup with sheet protected | Excel Discussion (Misc queries) | |||
| Group and ungroup protected sheets | Excel Discussion (Misc queries) | |||
| Can't Group or Ungroup in Protected Cells | Excel Programming | |||
![Metallo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
