macro error

  • Thread starter Thread starter mika.
  • Start date Start date
M

mika.

Whenever I press enter or tab., etc. to exit a cell I get
the error "The macros in this project are disabled.
Please refer to the online help or documentation of the
host application to determine how to enable macros." The
thing is, I do not believe I have any macros - I was
playing around before but I believe I deleted them all.
(When I go to Run Macros, there are none, and when I view
code under General Declarations and Work Sheet, there is
no code listed). Does anyone know of any solution to this
problem other than to change my Macro security from High
to Medium?

Thanks!
 
Mika,

Sounds as if you might have some event macros. In the VBE, open the sheet
module for the sheet you were in (double click it in the VBE project
Explorer) and look for code there. Also look in module ThisWorkbook.

Earl Kiosterud

Mvpearl omitthisword at verizon period net.
 
Hi Early,

I checked the sheet module code..nothing. I can't seem to
find the module ThisWorkbook...can you help me with this?

Thanks.
 
It doesn't look like I have any event macros (nothings
seems to be in the VBA code...)...any thoughts?
 
Back
Top