Hi there, I'm having some trouble with a workbook I'm trying to make. I want the user to be able to put in a state into a cell, click a button, and come up with a report view that has been tailored to their selection.
In my VBA code I have a line:
ActiveWorkbook.CustomViews("NY2008").Show
Ideally, I'd want it to be something like:
ActiveWorkbook.CustomViews(A1).Show
The user would specify "NY2008" into cell A1.
However, the formula doesn't seem to work with this.
Is it possible to have the ActiveWorkbook.CustomViews() command pull the name of the custom view from a cell some other way?
In my VBA code I have a line:
ActiveWorkbook.CustomViews("NY2008").Show
Ideally, I'd want it to be something like:
ActiveWorkbook.CustomViews(A1).Show
The user would specify "NY2008" into cell A1.
However, the formula doesn't seem to work with this.
Is it possible to have the ActiveWorkbook.CustomViews() command pull the name of the custom view from a cell some other way?