Hidden macro

[Guest]

Hi. When I go to share my workbook, I receive a message that "This workbook
contains macros recorded or written in visual basic. Macros cannot be viewed
or edited in shared workbooks."

I have written macros with this workbook before, but believe I have deleted
them all. When I look in the modules, I do not see any. Any ideas why I
still get this message?

Thanks,
Mike.

 

[Guest]

Hi, again.

I was able to get this to disappear by completely deleting the modules
associated with the workbook. I still don't understand why this was
occurring, though ..

Thanks,
Mike.

 

[Bob Phillips]

Because if the workbook has modules, then Excel assumes it has code. It
doesn't bother to check whether the module are empty or not.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[RichardSchollar]

Mike

Excel doesn't look at the contents of the Standard modules - it simply
checks if they exist (if they do - it gives the warning). So as you
rightly found, you need to remove them from the workbook to avoid that
message.

Best regards

Richard