I would like to hide formulas in Excel Sheet without lock the worksheet or workbook.
Please help if anyone can.
Thanks.
I would like to hide formulas in Excel Sheet without lock the worksheet or workbook.
Please help if anyone can.
Thanks.
How hidden do you want it? You can always copy and paste values after you run the formulas.
Aside from that you could open a tab, write all the formulas on that tab. Open another tab in the same workbook and then have that tab reference the values on the hidden tab. That's not *very* hidden, granted.
Those are what I can think of - someone with a better grasp of excel will probably come along with a better suggestion.
Possibly using VBA, otherwise, I think you can only do this by protecting the sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
and as asked, how hidden do you want it, another option is to hide the formula bar (View, uncheck formula bar). doesn't really do much, but just wanted to put another option because we don't know what the full purpose is.
Hiding formules you can do this by protection your sheet
also do right click on that cell formatcells and protection and then cekc the box hide
This will hide the formules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks