Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Curser will not stop selecting cells | Excel Discussion (Misc queries) | |||
Stop selecting blocks of cells | New Users to Excel | |||
prevent user from selecting and changing a sheet | Excel Programming | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions |