Notifications
Clear all
Topic starter
How to protect a assign name [ for a defined data range] once defined , so that user can not erroneously deleted or change the data defined.
Posted : 13/03/2020 9:15 pm
Hi David
You can try hiding the range name with this code:
ThisWorkbook.Names("YourRangeName").Visible = False
Cheers
Sunny
Posted : 14/03/2020 3:53 am
Topic starter
Thanks Sunny, will try on this code!
Posted : 17/03/2020 7:52 pm
