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

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.

" wrote:

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
oups.com...
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

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

On 12 Sep 2006 12:05:36 -0700, wrote:

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