G
Guest
Hi All
Is there a way I can hide formulas, without protecting the sheet
Is there a way I can hide formulas, without protecting the sheet
F
Frank Kabel
Hi
no you have to protect the sheet to make this work. Why is protecting a
sheet not an option for you?
no you have to protect the sheet to make this work. Why is protecting a
sheet not an option for you?
J
JE McGimpsey
No - is there a problem with protecting the sheet?
D
Don Guillett
These would work for some users.
You could set the scroll area.
You could have font and background color the same
You could set the scroll area.
You could have font and background color the same
N
Norman Harker
Hi Jinx!
You can achieve the same effect.
Select all cells [Press button at junction of row or column letters
or use Ctrl + A]
Format > Cells > Protection
Remove check from "Locked"
Place check in "Hidden"
OK
Tools > Protection > Protect Sheet
[Optional] Give and Confirm Password
OK
You find now that all formulas are hidden but non of the cellsis
protected.
This could be a PITA if you have formulas that return ""
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
You can achieve the same effect.
Select all cells [Press button at junction of row or column letters
or use Ctrl + A]
Format > Cells > Protection
Remove check from "Locked"
Place check in "Hidden"
OK
Tools > Protection > Protect Sheet
[Optional] Give and Confirm Password
OK
You find now that all formulas are hidden but non of the cellsis
protected.
This could be a PITA if you have formulas that return ""
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
G
Guest
Hi Frank
Protecting the sheet is not an option because the formulas which I want hide are linked to address'es that i need to change when a country is selected from a drop down list, when I select a country from the list when the sheet is protected I get the message "the cell or chart you are trying to change is protected and therefore read only"
I also have another problem I have a cell with data validation =AND(LEN(D11)<=34,EXACT(D11,UPPER(D11))
is there any way I can stop someone copying information from another sheet into this cell using ctrl c and ctrl
with incorrect information in it
As always any help you could give me would be greatly appreciated
----- Frank Kabel wrote: ----
H
no you have to protect the sheet to make this work. Why is protecting
sheet not an option for you
-
Regard
Frank Kabe
Frankfurt, German
Protecting the sheet is not an option because the formulas which I want hide are linked to address'es that i need to change when a country is selected from a drop down list, when I select a country from the list when the sheet is protected I get the message "the cell or chart you are trying to change is protected and therefore read only"
I also have another problem I have a cell with data validation =AND(LEN(D11)<=34,EXACT(D11,UPPER(D11))
is there any way I can stop someone copying information from another sheet into this cell using ctrl c and ctrl
with incorrect information in it
As always any help you could give me would be greatly appreciated
----- Frank Kabel wrote: ----
H
no you have to protect the sheet to make this work. Why is protecting
sheet not an option for you
-
Regard
Frank Kabe
Frankfurt, German
F
Frank Kabel
Hi
for the first question:
- unlock the cells for which you want to allow entries (goto 'Format -
Cells - Protection' and uncheck 'Locked')
- There's no other solution for hiding formulas
For the second question:
- not without VBA. This is a drawback of data validation
for the first question:
- unlock the cells for which you want to allow entries (goto 'Format -
Cells - Protection' and uncheck 'Locked')
- There's no other solution for hiding formulas
For the second question:
- not without VBA. This is a drawback of data validation
F
Frank Kabel
Hi
I'm confused
how do you want to change the formula if you enter a different value in
C12?
I'm confused
how do you want to change the formula if you enter a different value in
C12?
F
Frank Kabel
Hi
if you like could you email me your file and I'll take a look at it
email: frank[dot]kabel[at]freenet[dot]de
Should be no problem if the cell value is changed by a formula if you
protect your sheet.
if you like could you email me your file and I'll take a look at it
email: frank[dot]kabel[at]freenet[dot]de
Should be no problem if the cell value is changed by a formula if you
protect your sheet.
G
Guest
Hi Frank
Marked the cells as hidden instead of locked and it's working fine now
cheer
----- Frank Kabel wrote: ----
H
if you like could you email me your file and I'll take a look at it :-
email: frank[dot]kabel[at]freenet[dot]d
Should be no problem if the cell value is changed by a formula if yo
protect your sheet
-
Regard
Frank Kabe
Frankfurt, German
Jinx wrote
Marked the cells as hidden instead of locked and it's working fine now
cheer
----- Frank Kabel wrote: ----
H
if you like could you email me your file and I'll take a look at it :-
email: frank[dot]kabel[at]freenet[dot]d
Should be no problem if the cell value is changed by a formula if yo
protect your sheet
-
Regard
Frank Kabe
Frankfurt, German
Jinx wrote