Advanced | Excel Semi-Pro | Page 2

Advanced

Hide or Show Names in Excel with VBA

November 6, 2010 Advanced
Thumbnail image for Hide or Show Names in Excel with VBA

If you’ve discovered how useful Names can be in a spreadsheet, you may also know they can get-in-the-way-if-you-have-too-many. Just check out the Name Box in the picture to the right. Each Name has a Visible property that’s set to TRUE by default. You can hide a Name by changing the Visible property to FALSE, but […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …