Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a macro that is able to prevent users from selecting cells in my
workbooks. I can accomplish this in the workbook that contains my macro with a worksheet open event: ThisWorkbook.Sheets("Form").EnableSelection = xlNoSelection However, my macro is creating other workbooks that I'd like to have the same protection on. Is there a way to place a worksheet open event for disabling selections into a new workbook that I create? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run code remotely | Excel Programming | |||
need code for disable selection of locked cells | Excel Programming | |||
Disable menu selection | Excel Discussion (Misc queries) | |||
VBA - Run Macros Remotely? | Excel Programming | |||
Disable selection of shapes | Excel Programming |