Macro doesn't work when shared

**rasmus1166** · 11-10-2011, 07:06 AM

Hi,
I have a Macro that works brilliantly but stops working when shared. When attempting to share, I get a warning error saying: This workbook contains macros recorded or written in Visual Basic. Macros cannot be viewed or edited in shared workbooks.

If I say ok, anywhere I click, I get an error message saying: Run-time error '1004': Application-defined or object-defined error

The code is as under:

Please Login or Register  to view this content.

In addition, I used conditional formatting, as explained in this video:

http://www.youtube.com/watch?v=bGjqD...el_video_title

I really need to share the Workbook with this Macro running... Hope someone can shed some light on the issue.

Thanks in advance!!

**rasmus1166** · 11-10-2011, 08:20 AM

anyone??

please???

**romperstomper** · 11-10-2011, 08:22 AM

Change the code to:

Please Login or Register  to view this content.

and it should work.

**rasmus1166** · 11-10-2011, 09:27 AM

oh man you're a genius!!!

thank you thank you thank you!!!!!

Bless your brain! ^^

**romperstomper** · 11-10-2011, 10:00 AM

You are welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save