Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem with reference
In tools=Options, Edit tab, is "edit directly in cell" unchecked? If so,
check it. That should change this behavior. -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... I have multiple cells on sheet1 in workbook A referencing cells in sheet 1 of workbook B. I also have sheet1 in workbook A protected. When I double click any cell on sheet1 in workbook A, I get the expected message saying the workbook is protected, however after I click OK, it trys to bring up Workbook B. See workbook B has macros so the dialog asking to enable or disable macros pops up. If I click Enable Macros Workbook B opens. If I click X workbook B does not load. I dont want Workbook B loading period. Why is it doing this and how do I prevent workbook B from being opened? Thanx in advance Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem with reference
It was checked. That did not work.
-----Original Message----- In tools=Options, Edit tab, is "edit directly in cell" unchecked? If so, check it. That should change this behavior. -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... I have multiple cells on sheet1 in workbook A referencing cells in sheet 1 of workbook B. I also have sheet1 in workbook A protected. When I double click any cell on sheet1 in workbook A, I get the expected message saying the workbook is protected, however after I click OK, it trys to bring up Workbook B. See workbook B has macros so the dialog asking to enable or disable macros pops up. If I click Enable Macros Workbook B opens. If I click X workbook B does not load. I dont want Workbook B loading period. Why is it doing this and how do I prevent workbook B from being opened? Thanx in advance Todd Huttenstine . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem with reference
Ok, I can reproduce that.
for the worksheet, change the EnableSelection Property to either xlUnlockedcells or xlNoSelection then you will get the message on a double click, but it shouldn't try to open the linked workbook. Note that this property must be set each time the workbook is opened - so you would need to do it in the workbook_open event or other appropriate event. (of course if macros are disabled - no go). -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... It was checked. That did not work. -----Original Message----- In tools=Options, Edit tab, is "edit directly in cell" unchecked? If so, check it. That should change this behavior. -- Regards, Tom Ogilvy Todd Huttenstine wrote in message ... I have multiple cells on sheet1 in workbook A referencing cells in sheet 1 of workbook B. I also have sheet1 in workbook A protected. When I double click any cell on sheet1 in workbook A, I get the expected message saying the workbook is protected, however after I click OK, it trys to bring up Workbook B. See workbook B has macros so the dialog asking to enable or disable macros pops up. If I click Enable Macros Workbook B opens. If I click X workbook B does not load. I dont want Workbook B loading period. Why is it doing this and how do I prevent workbook B from being opened? Thanx in advance Todd Huttenstine . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange problem | Excel Discussion (Misc queries) | |||
Strange Problem | Excel Discussion (Misc queries) | |||
Strange Problem... | Excel Discussion (Misc queries) | |||
Strange Excel problem | Setting up and Configuration of Excel | |||
Strange Excel Problem | Setting up and Configuration of Excel |