+ Reply to Thread
Results 1 to 6 of 6

Working Macro not auto updating

Hybrid View

  1. #1
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Working Macro not auto updating

    Also:

    Did you put the code in the Clients worksheet's code module and not in a standard code module like Module1?

    Do you want it to run on any change to the worksheet?
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  2. #2
    Registered User
    Join Date
    12-01-2011
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    7

    Re: Working Macro not auto updating

    Hi, thanks for the help, I did change it to "Private Sub" (still not working) and it shows in both the worksheet code and
    under Module1. See Pictures, and yes I want it to run after any update withing that worksheet. What am I missing?
    Module1.JPGSheetModule.jpg

+ 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. Working with Dates, VB MAcro to Auto Filter on last 7 days
    By Rikkdh in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-20-2013, 10:01 AM
  2. Updating pivot table filters through a macro has stopped working, help please
    By JasperTata in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2012, 09:53 AM
  3. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  4. Auto list updating not updating
    By khank in forum Excel General
    Replies: 8
    Last Post: 05-28-2011, 11:03 PM
  5. Auto Macro for updating Current Month
    By dandavis1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2010, 05:37 AM

Tags for this Thread

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