Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent users selecting multiple cells?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent users selecting multiple cells?
Hi Angus
A macro can do everything. So assuming macros are enabled, running, healthy, well written and adored. Rightclick the sheet tab, choose "View code", paste this in: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target(1).Select End Sub .... but it is not a nice thing to do. Nothing "overriding" is. -- HTH. Best wishes Harald Followup to newsgroup only please. "Angus Comber" wrote in message ... Hello If a user ttempts to select multiple cells or clicks on the top left to select all rows I want to just select the top left cell in the selection - overriding Excels usual behaviour. Can I do this? Please let me know how? Angus Comber |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent users selecting multiple cells?
"Chip Pearson" skrev i melding
... Just to keep the macro code "healthy, well-written, and adored", you might want to disable events in the macro. Ok, I want that :-) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I prevent users selecting multiple cells?
Try menu
tools/options/ and uncheck "row and column headers" under the view tab Tony. Angus Comber wrote in message ... Hello If a user ttempts to select multiple cells or clicks on the top left to select all rows I want to just select the top left cell in the selection - overriding Excels usual behaviour. Can I do this? Please let me know how? Angus Comber |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you prevent users from changing certain cells? | Excel Worksheet Functions | |||
Prevent Users from Selecting Cells | Excel Worksheet Functions | |||
How do you prevent users from pasting over validated cells? | Excel Discussion (Misc queries) | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) |