Hi Joel,

1. No Class modules
2. Not sure what you mean by searching for the error message throughout the
project. The error message presented is an Excel error message indicating
that the macros are disabled, rather than a VBA error type.

Had a quick look at the links provided. On the first, Martin Brown states
quite confidently that "it can't be that". As I'm not registered on CodeCage,
I can't reply directly, but I can assure that it "is that". Adding a full
password stops all code in the workbook, taking the password off again allows
them to function correctly. According to a post on RDB's site, it's not a
consistent problem, but does occur - his suggested solution involves editing
the registry to bypass the issue.
http://www.rondebruin.nl/password2007.htm
The 2nd link provided returns a 404.

Cheers,
DS



"joel" wrote:


Two things to try

1) See if there are any Class modules.
2) Search for the error message in VBA and check the option to look in
entire Project (default is current module).


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170364

Microsoft Office Help

.