hide formulas

P

Patti

I created a template and some of the cells contain formulas. I protected the
document so you can't click on the cells with text, but when I want to reuse
the form and clear the data I input, it clears the formulas. How can I clear
the cells with formulas without clearing the formula itself?
 

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

Cumulative formula for word table 0
Columns appearing from nowhere, formatting going weird 0
Set as Default Template not working 0
Password protect new workbooks from template 0
Open my default template when right click, select New MS Word doc within a folder 0
Count Number of Unique Cells That Don't Have Certain Characters 0
I have a document with 8 different templates on it. 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top