Hi guys
i have data with formulars in my excel file
but i want to hide formulars stil file to works as normal while i put data
Hi guys
i have data with formulars in my excel file
but i want to hide formulars stil file to works as normal while i put data
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
Select the cells you want to hide the formulas in. Right click and go to "Format Cells". Click on "Protection". Click "Locked" & "Hidden". Protect your worksheet. Version 10 is under "Review" Tab.
It does'nt work
sorry can you attacha sample file with hiden formular
Did you read the article and/or follow the on-screen instructions regarding sheet protection? File attached.
Aplogies for the delay, but my www access is terribly poor at the moment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks