• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help to share workbook that contains a macro

Kellis

Member
Evening

I am looking for help on a spreadsheet I need to share a workbook which contains a macro, I share the workbook but when I run the macro I receive an error.

I know it can work because the predecessor to this book works fine. I cannot see where the problem lies, any suggestions on fault finding.
 
What does the error message say when you run the macro?
Note that with a shared workbook, you can't edit the macro code or delete worksheets, or a few other misc. actions that edit workbook structure. If your macro is trying to do any of those, it will fail.
 
Thanks Luke, the spreadsheet is at work and I am currently off, I will answer on Friday, hopefully you will be able to help then.
 
Back
Top