Excel 2007 Protect Sheet Expand Groups

Excel 2007 Protect Sheet Expand Groups. To protect those columns, I simply set manually the Locked All i want is to go on entering data into the protected sheet by auto expanding the table. I have tried checking boxes when in the protection dialogue box such as "Format columns", with no success.

Excel Mania: EXCEL 2007-RIBBONS (Hulda Jordan)

Protect cells, to specifically allow or In the screencast below, you'll see me work through several important types of protection in Excel. Unfortunately when password protecting your worksheets, there is no option to check that will enable you to allow users to use the expand/collapse buttons for cell groupings. Enter a password and click OK.

What I need is how to hide some specific columns with pw but the rest of the work sheet and the workbook is free.

Click on Tools, Protection, and Unprotect Sheet.

Create an Outline : Outline « Data Analysis « Microsoft ...

Protecting spreadsheet elements - Microsoft Excel 2007

Grouping Columns in Excel | How to Enable Grouping Columns?

Excel 2007 Pivot Table Grouping Data - Microsoft Community

Protecting workbook elements - Microsoft Excel 2007

Exporting a SharePoint List to an Excel 2007 Spreadsheet ...

Group Rows and Columns in an Excel Worksheet

Microsoft Excel 2007 – Review Tab | Softknowledge's Blog

How to Take Off Excel Password

There have been a few references online to some internal coding (VBA?) that might be a solution, but the directions I've seen aren't very clear. I want to be able to protect the sheets, to protect some formulas and such from user intervention, but it seems there's no way to do that and still allow the user to expand or. It's possible, and not very difficult, to get past Excel's password protection.