Protecting Worksheet
Protecting Worksheet
(OP)
I protected my worksheet from the tools-protection-protect sheet menu but it seems it can be manipulated when copied into a new work sheet. I want my worksheet when copied to another worksheet, the formulas will not be copied or in other words, only the values and no formulas will be copied as if it is pasted with the command, paste special-values only. i am not well-versed with excel and i hope someone from the board will teach me how to do it. thank you very much!





RE: Protecting Worksheet
something to think about...
insert another worksheet and enter formulas to obtain the information/data/values you choose for copying. hide all other worksheets & protect visible worksheet. when copying from protected worksheet to another worksheet is accomplish, the user will only see the formula "=?", where ? represents cell with calculated value. basically, create a dedicated worksheet with output values only and calcs are accomplish on another worksheet.
good luck!
-pmover
RE: Protecting Worksheet
TTFN
RE: Protecting Worksheet
You could create a macro and adjust the code, then create either a shortkey or an icon to accomplish the task. The problems with the macro is that that
1) The code isn't efficient (too much extraneous code)
2) If your cells aren't sequential (i.e. a1,b1,a2,b2,
etc), you might have an issue cutting and pasting.
3) If you aren't familiar enough with programming with VB
or VBA, cleaning up the code is more than a pain.
RE: Protecting Worksheet
The suggestion from IRstuff to make a PDF file seems a better way to protect your work.
RE: Protecting Worksheet
http://the-ciba.com/vbaler/index.html
Can't say how all that compiler business works now, but back then, the idea was to take a spreadsheet and compile it into a stand-alone, executable program that didn't need having Excel, Lotus, etc. installed on your computer. As I understood back then, in its compiled form, the spreadsheet formulas would be tamper-proof.
I never did go anywhere with that option back then so I can't offer any pros/cons about that approach.
RE: Protecting Worksheet
I just tried a new excel tool called TK Player. The equations exist in TK Solver and are distributed in a scrambled version as an Excel App via TK player. The end user can solve with his own inputs and even link other cell inputs within excel. The TK developer has the ability to let the user see the equations or just the inputs and outputs. The end user does a 1 time Free download from a website of the Player.
This new tool should solve your problem.
It is being released next Monday at www.uts.com
RE: Protecting Worksheet
But as quite rightly pointed out, lot of sites out there give away Excel password cracking methods! Stop average user perhaps.
RE: Protecting Worksheet
Just so you know Guidoo is right, there is not any protection that will protect formulas in an EXCEL spreadsheet. If you have Lotus or Quattro or about any other spreadsheet you can open any EXCEL file and see the formulas. The excel file may not work in a brand X program, but you will see the formulas.
If you want a quick stand-alone spreadsheet program that can protect the formulas try Bailer.
http://www.the-ciba.com/vbaler/
D23
RE: Protecting Worksheet