VBA Code needs to check for Shared Workbook

N

Newby

Does anyone have some VBA Code that will check to see if the workbook is
currently "Shared"? The problem that I have is that I have an auto comments
feature that adds a cell comment whenever a change is made, I discovered that
when I use a text = cmt.text for a shared workbook it actually copies the
cell comments back into the comment box twice, this doubling effect makes for
very large and repeated comments, whereas when you use this comment feature
on a non shared workbook then cmt.text is needed to keep the existing
comments into the comment box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top