Hidden macro
 

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.

Hidden macro
 

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.

Hidden macro
 

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.

Hidden macro
 

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.