I have written an application that formats a spreadsheet using data that a
user pastes into it. This spreadsheet that gets formatted is any spreadsheet
within the workbook that the application was built for. Any of the
spreadsheets that gets formatted are all formatted the same way, with the
same column layout, headers, etc.

There are different users of this application, and each has their own
preference for which columns get hidden for any given situation. So, I'd
like to have each user be able to define their own set of Custom Views that
they can save with the Excel workbook, and then select the Custom View to use
for any given sheet.

In testing, it seems that each Custom View is somehow linked to the
worksheet that it was created for, and cannot be applied to any other
worksheet. Is there a way that a Custom View can be altered in VBA to work
with a sheet other than the one it was created with? Any other ideas about
how to approach this?