Stop user selecting more than one sheet at once?

Hi,
Help would be apprecitaed:
Within a given workbook i wish to stop users selecting more than one sheet
at once. (To make sure data is not overwritten in both sheets as these cells
are llinked and would be very hard to undo)
Thanks in advance,
Rob

why don't you just protect the cells/worksheets you don't want overwritten??
(tools-protection)

"RobW" wrote:

> Hi,
> Help would be apprecitaed:
> Within a given workbook i wish to stop users selecting more than one sheet
> at once. (To make sure data is not overwritten in both sheets as these cells
> are llinked and would be very hard to undo)
> Thanks in advance,
> Rob

Tom,
thanks but these cells do need to be overwitten, I just need to stop then
both potentially being overwritten at once as they link to very different
places. (the sheet is already protected except for these cells.)

okay..

Well? I don't know of a property (there may be one) BUT Recently, I did
something that could work..

The number of tabs in the workbook I was working on was getting rather
large. So I made a user form. On that form I had a list of all the
worksheets. When a user clicked on one it got the focus. You could use
something like that and then hide the sheet on the deactivate event. maybe??

*** displaying the user form I did it modeless (non-modal) so the list of
sheets is always on the screen and they can work around it.

"RobW" wrote:

> Tom,
> thanks but these cells do need to be overwitten, I just need to stop then
> both potentially being overwritten at once as they link to very different
> places. (the sheet is already protected except for these cells.)

sorry to put another dampener on you efforts but hiding a sheet is going to
mean the graphs that are linked to it won't display when the sheet is hidden.


"TomHinkle" wrote:

> okay..
>
> Well? I don't know of a property (there may be one) BUT Recently, I did
> something that could work..
>
> The number of tabs in the workbook I was working on was getting rather
> large. So I made a user form. On that form I had a list of all the
> worksheets. When a user clicked on one it got the focus. You could use
> something like that and then hide the sheet on the deactivate event. maybe??
>
> *** displaying the user form I did it modeless (non-modal) so the list of
> sheets is always on the screen and they can work around it.
>
> "RobW" wrote:
>
> > Tom,
> > thanks but these cells do need to be overwitten, I just need to stop then
> > both potentially being overwritten at once as they link to very different
> > places. (the sheet is already protected except for these cells.)

So don't hide the sheet. Just change the focus/activesheet.

--
Regards,
Tom Ogilvy


"RobW" <[email protected]> wrote in message
news:[email protected]...
> sorry to put another dampener on you efforts but hiding a sheet is going
to
> mean the graphs that are linked to it won't display when the sheet is
hidden.
>
>
> "TomHinkle" wrote:
>
> > okay..
> >
> > Well? I don't know of a property (there may be one) BUT Recently, I did
> > something that could work..
> >
> > The number of tabs in the workbook I was working on was getting rather
> > large. So I made a user form. On that form I had a list of all the
> > worksheets. When a user clicked on one it got the focus. You could use
> > something like that and then hide the sheet on the deactivate event.
maybe??
> >
> > *** displaying the user form I did it modeless (non-modal) so the list
of
> > sheets is always on the screen and they can work around it.
> >
> > "RobW" wrote:
> >
> > > Tom,
> > > thanks but these cells do need to be overwitten, I just need to stop
then
> > > both potentially being overwritten at once as they link to very
different
> > > places. (the sheet is already protected except for these cells.)