invisable macro?

S

Surf

I am documenting someone else's workbook - on one of the sheets, it is
apparent that a macro runs when I enter data in an empty cell in a particular
column. The problem is, when I try to see the macro to delete it, no macro
shows up. (Tools/macro .... ).

What is happening? Thanks.
 
G

Gord Dibben

Surf

Right-click on the sheet tab and "View Code"

To delete it, select all code and Edit>Clear.

Save the workbook.

Gord Dibben Excel MVP
 
S

Surf

Got some great suggestions, but still having a problem. I went into VB and
deleted "all" in every page of the workbook and the workbook as instructed.
This workbook doesn't have anything else that shows up to delete.... I do not
get a macro warning when I open the file anymore, but ... I can see the macro
work when I enter a number into a particular cell ... aaaack!
 
D

Don Guillett

assuming you cleared all macros in all sheet code including ThisWorkbook,
removed all regular modules (not just deleted the code), and SAVED the
workbook, closed excel and came back, it should be gone... scary Rod Serling
music here.
 
D

Debra Dalgleish

What happens when you enter a number in that cell?

Perhaps the cell has Data Validation, which is giving you a message
(Data>Validation)

Or the cell may have conditional formatting
(Format>Conditional Formatting)
 
S

Surf

The sheet has several columns of data. In the last row, where all columns
are blank, if I enter a number in the cell at the end of the first column of
data, when I press enter, the number is entered in that cell, then the curser
bounces to each of the columns, to the right, entering formulas. It looks
like a macro written to help with data entry. It doesn't happen in any other
row unless the cells are completely empty. It also does't work if I enter an
alpha instead of number.

The guy who owns it now was not aware it was there, but I did find out that
it has been handed down for several years and may have originally been in a
much older version of excel... if that matters.

Thanks again.
 
Top