Force Selection of Custom Views

[scott.ranzal]

Got a spreadsheet with a series of custom views that I would like to
force end users to use versus just using the complete spreadsheet.
Tried attaching a macro, but i was hoping for something simplier like
document opens with a drop down selection list and you choose views
from that

any ideas?

scott

 

[Guest]

Try creating a list. Select validation from the Data menu bar. Then select
list from the drop down and then you will get a field to reference your list.
Hence, the list must be created somewhere in your worksheet so you can
selected. What I usually do is after creating my list is hiding the column
that contains my list and I also protect the cells.

 

[RagDyer]

How about adding a *built in* "Custom Views" window to your toolbar OR your
menu bar?
It displays the name of the current view being displayed.
You can expand it to display a drop-down of *all* the views in the sheet.
Click on any particular view and it's brought up, much like a hyperlink.

Right click in the toolbar and choose "Customize",
Under the "Commands" tab, in the left window click on "View"
In the right window, click on and drag the "Custom View" to either your
toolbar or your menu bar.

There's usually more room on the menu bar, and you can enlarge the size of
this window if you happen to have long names.

 

[Gord Dibben]

Private Sub Workbook_Open()
Application.Dialogs(xlDialogCustomViews).Show
End Sub

will open the workbook with the custom views dialog open.

To "force" users to pick a view is another matter.

I suppose you could render the workbook unusable if the users disabled macros or
did not pick a custom view from the list.

Depends upon how much work you are willing to put in.


Gord Dibben MS Excel MVP