SMartview multi-grid ad-hoc, using VBA to change the grid range?
Boberto asked 4 years ago
I have a muti-grid adhov smartview pull. Ive noticed the grid ranges can be finicky and you cant change them in the name manager as they reset when you refresh.
Is there some VBA that will allow me to change each grid size to how I want?
thanks
Is there some VBA that will allow me to change each grid size to how I want?
thanks
Answers
Patrick Roth Staff answered 4 years ago
you cant change them in the name manager as they reset when you refresh.
You can’t change the names of the columns in SmartView itself. You can, however, change them in either SLB (if a smartlist builder report) or otherwise the Field Maintenance window inside of SV.
Is there some VBA that will allow me to change each grid size to how I want?
No, there isn’t VBA or another language embedded into SV.
You can add a feature request to change the grid size here:
https://www.eonesolutions.com/forum/type/smartview-feature-requests/
You can’t change the names of the columns in SmartView itself. You can, however, change them in either SLB (if a smartlist builder report) or otherwise the Field Maintenance window inside of SV.
Is there some VBA that will allow me to change each grid size to how I want?
No, there isn’t VBA or another language embedded into SV.
You can add a feature request to change the grid size here:
https://www.eonesolutions.com/forum/type/smartview-feature-requests/