"unprotect project" warning

[michaelr]

I've just upgraded from Office 97 to 2003
Every time i open and close an Excel doc, i get a message saying 'Compile error in hidden module [name]
The Help advice here isn't clear at all: it says this means that "A protected module can't be displayed.", and that the solution is to 'unprotect the project'. (Not clear how you unprotect a project - the HElp is useless
I don't get it - this is not a major problem (you can still open and clsoe the file by hitting OK) but it's irritating

Any ideas?

 

[A.W.J. Ales]

Michael,

Is this happening on one file only or does it appear on opening of any file.
If it's the second, I don't know how to help you, but if it's the first,
it's likely that the file (obviously without your knowing it) is containing
a VB module.

To check this open the file, press <ALT>+F11, open the Project Explorer (if
not allready open) and look for your filename (VBAProject(Filename)).
If it has a +sign in front of it "unfold" it. You now should be able to
see icons of all your sheets + an icon called ThisWorkbook.
(They can but need not be placed in a "folder" called "Microsoft Excel
Objects").

If you see more items in your project ( either folders called (Class)
Modules and/or Forms or just - if you don't see folders Modules and or
Userforms) your file is containing a VB project).

Even if you only see icons of sheets and of ThisWorkbook it still is
poosible.
Right click on each of your sheets and on the ThisWorkbook icons and select
View code to check of all of the modules are empty.

If you don't need this VB (provided it is there) you can delete the
modules/forms and "empty" the "modules" of your sheets/This workbook.
To close VB and to get back to the "normal" Excel view just press the X (Top
right) . It won't close Excel this time, just the VB editor.
Don't forget to save your file or everything will get back the next time.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

I've just upgraded from Office 97 to 2003.
Every time i open and close an Excel doc, i get a message saying 'Compile error in hidden module [name]'
The Help advice here isn't clear at all: it says this means that "A

protected module can't be displayed.", and that the solution is to
'unprotect the project'. (Not clear how you unprotect a project - the HElp
is useless)

I don't get it - this is not a major problem (you can still open and clsoe

the file by hitting OK) but it's irritating.