Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Named ranges
Hi,
If I want the named ranges to be hidden from the user, do I use the Visible property of the Name object? Or is there another way? Regards Pete |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding Named ranges
Nope, that's how to do it, in VBA.
Jan Karel Pieterse has a utility designed to improve working with defined names. It is a free add-in, and you can get it at http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "PO" <h wrote in message ... Hi, If I want the named ranges to be hidden from the user, do I use the Visible property of the Name object? Or is there another way? Regards Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
Hiding named ranges depending on a cell value | Excel Programming | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Hiding Named Ranges | Excel Programming |