Is there an Alternative for Defined Name Ranges created by a Macro?
I have found a way of creating Defined Names with a Macro ..
No this works fine but is it possible to not have the Defined Names in the Formula Manager but yet have the functionality going smooothly..
Please Login or Register to view this content.
When I tried changing the colour of a particular column based on different values using a Macro it worked fantastically without even showing anything in the conditional formatting..
Which means that if im distributing the file no-one will know how its done but yet it works like conditional formatting..
On similar grounds, is it possible to have the Defined Name Created but not shown when one goes to the Formula Manager?
I know that I can always lock the VBA Module code but trying to Protect the sheet sometimes causes some Worksheet_Activate,Change and Selection Change events to not fire...
Hope I have been able to explain correctly..