Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to hide a cell range


Need to completely hide a group of named cell ranges.

I have seen "Require a Password to View Hidden Worksheets in Excel - VBA Tutorial".

Looking for a cell range version of worksheets above.



Hi CMoore and welcome to the Forum. The solution will depend on your named ranges. Please edit your question to attach a representative Excel file (using the Add Files button below the text). Doubt I can answer before tomorrow. 
John_Ru (rep: 4937) Mar 19, '23 at 10:19 am
Hello Cmoore,
I agree with John. A sample file showing yor sheet layout and where the ranges are in relation to other cells will be very helpful. A simple way is to change the font colour to the same as the cell fill colour and then it won't show. But the cell value will still be visible in the formula bar. But, there is a way to keep the cell vaue from showing in the formula bar. Having a sample file will make providing a solution easier and more specific to your situation.

Cheers   :-)
WillieD24 (rep: 210) Mar 19, '23 at 6:41 pm
CMoore. Please respond to / comment on the requests above. We need you to help us so we can help you!
John_Ru (rep: 4937) Mar 22, '23 at 6:22 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login