Macro doesn't work when shared

[rasmus1166]

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]

anyone?? please???

[romperstomper]

Change the code to:

Please Login or Register  to view this content.

and it should work.

[rasmus1166]

oh man you're a genius!!!

thank you thank you thank you!!!!!

Bless your brain! ^^

[romperstomper]

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