Worksheet protect with query-based table

5

5GenTexan

I have a table with 3 columns based on a SQL db query, with a worksheet
column added to the table that is a formula I want to protect. There are 3
other non-table cells I want to protect.

If I protect the worksheet, I can't refresh the table, even if I unlocked
the table cells that are based on the query.
 

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

Setting column width in a table with a macro is not working 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
how to partially protect a pivot table based worksheet 8
Creating a Chart on form from selected data in query. 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Format column widths from one table to a separate table on same page 1
Consolidation Table from Different Excel Tabs with Different Format 1
List all tables, including document structure 0

Top