Using subtotaling and protecting a sheet at the same time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that is protected that has places for data entry that
works fine. It also has subtotaling to outline the sheet. Is there a way to
make the subtotal function work on a protected sheet. I have it running
currently thru a macro.

Thanks
Wayne
 
If you already have the outline/subtotals 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
'.EnableAutoFilter = 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
 

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

nesting sumproduct with subtotal 9
Subtotal function not available 3
Insert subtotal in a query database Excel 2007 3
Copying Subtotals to new worksheet 2
Changing my functions to use subtotals? 6
Macro To Remove Subtotals from ALL Worksheets 2
Subtotal question 4
Protection using the subtotal function 1

Back
Top