View Full Version : Solved: Remove Formula
Dear Sir,
A1=1
B1=1
C1="=A1+B1"
C1 displays 2
When cursor in in C1 Then Formula bar displays =A1+B1
I want to remove formula but value in C1 must remain.
Please help
matthewspatrick
07-20-2007, 09:41 PM
If you are working in the UI, just type a 2 into that cell :)
Again in the UI, to apply this over a range, use Copy/Paste Special.
To apply this to a range in code:
Range("C:C").Value = Range("C:C").Value
If you are working in the UI, just type a 2 into that cell :)
What is UI?
I do not want to type again.
Please suggest some other solution
JimmyTheHand
07-20-2007, 11:53 PM
UI is user interface.
Being in the UI means that you do things manually, by clicking and typing, instead of running a code.
By applying it over a range, Patrick meant the following
1. Select the cells with the formulas. E.g. select column C.
2. From menu, select Edit / Copy
3. From menu, select Edit / Paste Special
4. On the appearing form, select "Values"
5. Click OK
HTH
Jimmy
Ok thanks for helping
Is it possible to hide formula from c1
I mean calculation must updated in c1 but the formula should not appear.
Or formula should not be edit.
Thnaks
RichardSchollar
07-21-2007, 01:16 AM
You can do this by applying worksheet protection:
1. Right-click on the formula cell and choose Format Cells. On the Protection tab make sure the Hidden box is checked. Hit OK.
2. Now go Tools>Protection>Protect Sheet and hit OK.
Users now won't be able to edit/see the formula (you may want to apply a password to the protection so they can't simply unprotect the sheet).
Richard
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.