Giving colleagues VBA code - best suggestion

Hi all

I recorded a simple macro to identify any blank cells, conditional format these in red

Please Login or Register  to view this content.

My question is I I saved these in my personal workbook.. but I want to share these with multiple colleagues

what/how should i share it? they will need to use the code on multiple workbooks?

Thanks

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

You should avoid Selecting objects. This does the same thing without Selecting the range.

Please Login or Register  to view this content.

I agree with PrizeGotti. Save any macros you want to share/distribute in a separate file and give them that. If they load that first, or when they need it, they can call the macros from the "macro store". I have to be honest and say that I have never used a Personal Workbook.

Hi all,

Apologies - what would be the process if i've given them the macro WB, how do they run it in each workbook they will need to use the macro in?

@rayted

Please read and act upon post #2. Thank you.

Thanks for the rep.

We cannot take this discussion further until you act upon the instructions from the Moderator. Please apply Code Tags in your original post.

Yes, you can - this is a guideline (not a rule), but the OP hs been a member long enough to add the code tags himself. I should like him to so so, but the thread can continue. I shall get a bit irritated if he carries on ignoring me, though ...

LOL! Just noticed that he's given me rep for post #2, but done nothing about it.

@rayted - CODE TAGS, please!!!

Still a bit sensitive about "guidelines".

Please read and act upon post #2. Thank you.

Thread titles and code tags are now guidelines - I'd expect Gurus to reinforce the message, but we don't stop threads over it any longer.

Hope this helps.

We are also told to leave Moderation to Moderators. And that suits me just fine.

Had you not intervened, I would happily carry on. Now that you have, I will wait for the OP to respond. Simple.

I shall reply via PM so as not to clutter the thread.

Hi both,

My apologies - I hope I've successfully edited my post to be in line with the guidelines from @aligw :-) sorry!

Woo-hoo! Thanks - please remember to add them in future.