Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Views
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom Views
AFAIK, Custom Views are associated with the workbook, as each can contain
multiple windows, sheets etc. As you can neither read the info associated with a view nor apply it to another workbook, you would have to determine yourself the changes applied for each views; I don't think is advisable. The alternative is put the current data into a WB that contains the various views. If it is a single WB that all users access, you could provide a list of views based on the Username, if the views are named appropriately e.g John_TotalsOnly, Mary_TotalsOnly. Then loop through all the views, only adding those to a listbox that are LIKE Environ("Username"). Or if it's only hide/unhide rows/columns, you could save some suitable data in the users personal.xls and apply those settings to the ActiveSheet/ActiveWorkbook when triggered by the user from a button/menu entry. A few ideas anyway.. NickHK "Stu W" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Views | Excel Discussion (Misc queries) | |||
Custom Views!!! | Setting up and Configuration of Excel | |||
Custom Views | Excel Discussion (Misc queries) | |||
Using Custom Views | New Users to Excel | |||
Custom Views | Excel Discussion (Misc queries) |