Excel List on Protected Sheet

L

Lori H.

I have a range that is an Excel List.
Regardless of whether all cells in the list are unlocked (or if some columns
are locked), if the sheet is protected, the list doesn't activate (so the
list doesn't extend to include the new row).

Is there a way around that?
 

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

Dealing with the error: unable to filter on excel hc home school 0
Export BPMN Visio Chart to Excel 0
Drop down list control value in vba 2
Enabling Autofilter and Sorting in a Protected Sheet 2
Space at end of multi page list to accommodate new entries 1
Change states of some checkboxes from drop-down list? 5
Protected sheet - attempt to delete row = unmerged cells 5
Merging from an Excel file with graphics 1

Top