+ Reply to Thread
Results 1 to 3 of 3

How to apply VBA in every row

  1. #1
    Registered User
    Join Date
    01-30-2016
    Location
    DUBAI
    MS-Off Ver
    OFFICE 365
    Posts
    1

    How to apply VBA in every row

    Hi All,

    im trying to make some sort of a daily report where in column "R" has a drop down list of its status.

    i.e. in row 6.
    once the work is finished, the staff will choose "COMPLETED" in column R6.
    What i would like to happen is that whenever they chose that word, selected cells in row6 will be locked or protected.

    i've manage to create VBA but it only applies to row6 only. would like apply the same rule in every row.

    please advise.. VBA i created is here...

    ----------------------------------------------------------------------------
    Please Login or Register  to view this content.
    ---------------------------------------------------------------------------------------------

    Thank you in Advance !!!
    Last edited by Richard Buttrey; 01-30-2016 at 08:32 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to apply VBA in every row

    Hi and welcome to the forum. Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    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, it also maintains VBA formatting.

    To do this 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

    Since this is your first post I'll add the code tags for you but please remember for the future.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to apply VBA in every row

    Hi

    Try:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Apply Macro First UnprotectSheet After Apply Macro ProtectAgain Solved by : Sixthsense
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2014, 05:32 AM
  2. How do i apply...
    By banny85 in forum Excel General
    Replies: 1
    Last Post: 06-22-2011, 12:30 PM
  3. anyone know how to apply for a job
    By Cheeky Charlie in forum The Water Cooler
    Replies: 6
    Last Post: 01-30-2009, 05:37 AM
  4. Does an if then apply here?
    By loc066 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2008, 09:16 PM
  5. How to apply a weighting
    By Homer J in forum Excel General
    Replies: 0
    Last Post: 08-12-2005, 05:05 AM
  6. Apply all autofilters
    By malcomio in forum Excel General
    Replies: 1
    Last Post: 07-29-2005, 10:05 AM
  7. [SOLVED] How can I apply this calculation
    By Rory in forum Excel General
    Replies: 4
    Last Post: 07-26-2005, 03:05 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