Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please! Macro Error on Select Worksheet
When I try to select a cell on a particular worksheet,
excel will not allow me to select the cell, and instead tries to execute a macro and returns a "Macro not found" error message. This only happens when the worksheet is protected. Help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please! Macro Error on Select Worksheet
hi,
i don't know but your sheet may have an on change event. to find out close all other excel files press alt+f11 in the vb editor, in the left pane expant the vb project with your file name. double click the sheet in the left pane above the right pane are 2 boxes. in the left box ,click the down arrow and select worksheet. in the right box click the down arrow and click change. if code appears in the right pane, delete it. in the right box click the down arrow and click selection change. if code appears in the right pane, delete it if that does not stop your problem, you may have to go through all of the option in the right box. -----Original Message----- When I try to select a cell on a particular worksheet, excel will not allow me to select the cell, and instead tries to execute a macro and returns a "Macro not found" error message. This only happens when the worksheet is protected. Help! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Worksheet to print Macro | Excel Worksheet Functions | |||
why does this macro select the entire worksheet when run? | Excel Discussion (Misc queries) | |||
need a macro select all cells in a worksheet? | Excel Discussion (Misc queries) | |||
select worksheet to run macro | Excel Discussion (Misc queries) | |||
RUNTIME ERROR '1004' --- Select method of worksheet class failed | Excel Programming |