Error 1004 "Cannot edit a macro on a hidden workbook"

N

neil Crawford

Dear all,

I have EXCEL 2003 and everytime I try and open a file I
get Error 1004 "Cannot edit a macro on a hidden workbook.
Unhide the workbook using the unhide command".

I've gone to the help and done what it says - Set to
trust access to Visual Basic Project - but it doesn't do
any good.

Has anyone got an idea of how to fix this rather
irritating problem?

many thanks,

neil
 
D

Dave Peterson

I've never seen this error, but it sure sounds like something is trying to make
a change to some code.

This happens whenever you open ANY workbook--or just a single workbook?

If it happens all the time, you can use some techniques that Chip Pearson shares
on his web site:

http://www.cpearson.com/excel/StartupErrors.htm

Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)

Then one by one, you'll add one back and restart excel to see if that caused the
problem.

If it only happens with one workbook, I'd try to find the developer and show
him/her the problem.
 
Top