+ Reply to Thread
Results 1 to 1 of 1

Misunderstanding code and how to end Application Caller-Please help

  1. #1
    Registered User
    Join Date
    10-04-2016
    Location
    Raleigh, NC
    MS-Off Ver
    2013
    Posts
    3

    Misunderstanding code and how to end Application Caller-Please help

    I am a beginner in VBA and am currently having issues figuring this code out. Can anyone point me in the right direction? I have a load button on a master list and if the item has a quantity in column 3, it will automatically be unhidden in the next sheet with that quantity in it and then hide any other items that do not have a quantity. Am I doing this correctly?


    Please Login or Register  to view this content.
    Sub HideUnHide()
    Dim maxWidth As Long, myWidth As Long
    Dim myZoom As Single

    If Application.Caller = "LoadButton" Then
    If Worksheets("Pull_Sheet").Visible = xlSheetVisible Then
    Worksheets("Pull_Sheet").Visible = xlSheetVeryHidden

    ElseIf Worksheets("Pull_Sheet").Visible = xlSheetVeryHidden Then
    Worksheets("Pull_Sheet").Visible = xlSheetVisible
    Worksheets("Pull_Sheet").Activate
    ActiveSheet.Unprotect
    Range("A2:L2").Select
    ActiveSheet.Range("$A$2:$L$4272").AutoFilter Field:=3, Criteria1:=">=1"
    Range("A2").Select
    Worksheets("Pull_Sheet").Activate
    ActiveSheet.Protect
    Range("A2").Select

    End If


    End Sub[/CODE]
    Attached Files Attached Files
    Last edited by lucasoliver; 10-06-2016 at 10:06 AM. Reason: Added Code Tags / Corrected title. Please read and follow the forum rules! Link above in the menu bar.

+ 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] Represent (define?) a section of code with a variable (shorten long code lines)?
    By Gene@action in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2016, 03:59 PM
  2. [SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.
    By FragaGeddon in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-30-2015, 11:46 AM
  3. [SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-10-2015, 03:05 PM
  4. [SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.
    By Heinrich Venter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2014, 06:10 AM
  5. [SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table
    By cteaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2014, 08:01 PM
  6. Replies: 2
    Last Post: 03-09-2013, 04:30 AM

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