Excel Macros

  • Thread starter Thread starter datacomjoe
  • Start date Start date
D

datacomjoe

I have one workbook that displays the enable/disable macros dialog bo
when I open it. I never created a macro in this workbook and after
open the workbook it doesn't show any macros listed. With the macro
disabled I receive an error message whenever I attempt to update o
modify a cell. I thought there may be a macro virus attached but
virus scan doesn't show any.

Any help would be greatly appreciated.

-Jo
 
Hi
check the following:
- open the vBA editor (ALT+F11)
- remove all (empty) modules
- check the worksheet modules and the workbook modules for code rests
- close the VBA editor, save the workbook and try again
 
Thanks for responding Frank,

I looked though the Visual Basic Editor but didn't find any modules.
I'm not sure what you mean by "code rests," there doesn't appear to be
any modules for any of the sheets or the workbook. For each worksheet
I see the following.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

And for the workbook I see the following.

Private Sub Workbook_Open()

End Sub

These are empty and shouldn't have any effect on cell updates.

Some additional information. I have checked for any "conditional
formating" and there is none.

This has got me stumped. If I can't find it how can I remove it...

Joe

Attachment filename: macroproblem.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=544944
 
I Forgot to mention that I attached I cut down version of the Exce
Workbook to my previous reply.

The file name is: MacroProblem.xls

Jo
 
Hi
you have to delete just these statements (though they do nothing).
these are the 'code rests'
 
I've never heard of "code rests" either. <g>

Even those the worksheet code that you included isn't doing anything,
it's still seen as a macro. You can delete those empty procedures, and
the macro warning should disappear.

There are some instructions in the Excel FAQs on my web site:

http://www.contextures.com/xlfaqMac.html#NoMacros
 
Back
Top