cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Is there a way to lock certain cells in Mathcad 15?

adeters
1-Newbie

Is there a way to lock certain cells in Mathcad 15?

Is there a way to lock certain cells in Mathcad 15?

I am creating a calculation template and want to pass it on to coworkers, but I want to lock certain cells that should stay constant so they can't be edited without a password or something. Is this possible? I only see how to lock the entire file or all of the contents.

1 ACCEPTED SOLUTION

Accepted Solutions

5 REPLIES 5

May be so

Or so

StuartBruff
23-Emerald II
(To:adeters)

adeters wrote:

Is there a way to lock certain cells in Mathcad 15?

I am creating a calculation template and want to pass it on to coworkers, but I want to lock certain cells that should stay constant so they can't be edited without a password or something. Is this possible? I only see how to lock the entire file or all of the contents.

Do they need to see the constants?

If not, one option is to put them in a Mathcad "Area".   This is bounded section of a worksheet that can be "collapsed" and password locked.  It's useful for adding a library of commonly-used or domain-specific functions to a worksheet, and hiding them so that they don't detract from the actual content of the worksheet.

Another option is to keep them in a Reference file, and load that at the top of your main worksheet (or, at least, before you actually need them!).

Stuart

AndyWesterman
4-Participant
(To:adeters)

Right click on an equation , select properties then the protect tab.

un-tick the protect check box, and when you lock the file this equation can still be edited.

Note that properties such as the colour highlight can still be changed.

regards

Andy

Thanks so much for everyones help!

Top Tags