Home |
Search |
Today's Posts |
#1
|
|||
|
|||
After protecting excel unable to group & ungroup few colums
Unable to group & ungroup once excel is protected.
1. Few columns are selected & grouped. 2. Few cells are selected & locked 3. Sheet is protected. 4. Now when I try to ungroup the columns it displays a mesage that since the sheet is protected it can't be ungrouped Suggestion is to allow a checkbox while protecting the excel where I can allow users to use group- ungroup feature ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
After protecting excel unable to group & ungroup few colums
If you already have the Grouping applied, you can protect the worksheet in code
(auto_open/workbook_open??). Option Explicit Sub auto_open() With Worksheets("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableOutlining = True End With End Sub It needs to be reset each time you open the workbook. (excel doesn't remember it after closing the workbook.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm seetesh wrote: Unable to group & ungroup once excel is protected. 1. Few columns are selected & grouped. 2. Few cells are selected & locked 3. Sheet is protected. 4. Now when I try to ungroup the columns it displays a mesage that since the sheet is protected it can't be ungrouped Suggestion is to allow a checkbox while protecting the excel where I can allow users to use group- ungroup feature ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel, I seem to be "locked" on a cell and unable to click off. | Excel Discussion (Misc queries) | |||
Unable to open excel imports on new computer | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel sort option disabled--file name followed by "group" at top . | Excel Discussion (Misc queries) |