Results 1 to 15 of 15

Giving colleagues VBA code - best suggestion

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    833

    Giving colleagues VBA code - best suggestion

    Hi all

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

    
    Sub Blank_higlighter()
    '
    ' Blank_higlighter Macro
    '
    
    '
        Columns("A:P").Select
        Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
            "=LEN(TRIM(A1))=0"
        Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
        With Selection.FormatConditions(1).Interior
            .PatternColorIndex = xlAutomatic
            .Color = 255
            .TintAndShade = 0
        End With
        Selection.FormatConditions(1).StopIfTrue = False
    End Sub
    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
    Last edited by rayted; 10-05-2023 at 11:39 AM.
    Thanks,

    R.



Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 09-14-2022, 05:02 PM
  2. Replies: 5
    Last Post: 09-05-2016, 11:55 AM
  3. [SOLVED] Code won't run on colleagues PC
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2014, 07:15 AM
  4. [SOLVED] Giving suggestion list while typing
    By olivarsham in forum Excel General
    Replies: 1
    Last Post: 01-25-2013, 01:11 AM
  5. code explanation and suggestion
    By JohnSeito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2007, 08:04 PM
  6. code suggestion
    By sunkosi in forum Excel General
    Replies: 2
    Last Post: 05-04-2006, 10:30 PM
  7. Looking For A Suggestion About How To Write Code
    By abxy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2005, 03:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1