Thread: Hidden macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RichardSchollar RichardSchollar is offline
external usenet poster
 
Posts: 196
Default 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.