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.

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.

"Mike D." wrote:

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.

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)


"Mike D." wrote in message
...
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.

"Mike D." wrote:

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.

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


Mike D. wrote:
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.

"Mike D." wrote:

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.