Is there any way when I hide a sheet I can also hide the cell values in that sheet from everywhere,,, so the entire sheet and its calcs do not appear anywhere?
Is there any way when I hide a sheet I can also hide the cell values in that sheet from everywhere,,, so the entire sheet and its calcs do not appear anywhere?
Take a look here:
https://www.ablebits.com/office-addi...-sheets-excel/
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
thanks for the quick reply
As far as I read link it just very hides the sheet but does not stop the calcs from appearing elswhere...I just dont want the calcs and results of the hidden sheet to affect the workbook.... see pics,,, pic a is sheet one with out the hidden sheet,, pic 2 is the calcs with the sheet hidden and not showing what is within the hidden sheet...Attachment 638284Attachment 638285
Your picture links didn't lead anywhere. Anyway, pictures of sheets are no substitutes for excel sheets. All I can do to a picture is photoshop it!!
You can hide formulae, of course:
https://support.office.com/en-us/art...9-0c1b77a5356f
However, unless you attach a sample sheet explaining unambiguously what you want, I can't be of much further help.
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Make sure confidential info is removed first!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks