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

Stop user selecting more than one sheet at once?
 

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

Stop user selecting more than one sheet at once?
 

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.)

Stop user selecting more than one sheet at once?
 

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.)

Stop user selecting more than one sheet at once?
 

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.)

Stop user selecting more than one sheet at once?
 

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

--
Regards,
Tom Ogilvy


"RobW" wrote in message
...
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.)