+ Reply to Thread
Results 1 to 3 of 3

vba running by steps / hide code

  1. #1
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    vba running by steps / hide code

    Hi everyone,

    When I track variable values I press F8 for running code by steps but it always starting from beginning. Is any way to start this from any other place in my code?

    The additional question is how can I hide all vba code in my project from users?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: vba running by steps / hide code

    Press F8 you will find Yellow arrow to the left ..at the Sub MacrName() line
    Drag this arrow to the desired line you need to start debugging

    As for hiding VBA code :
    Tools >> VBA Project Properties >> Protection Tab >> Check Lock Project for viewing >> Type your password twice >> OK
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Re: vba running by steps / hide code

    many thanks YasserKhalil

+ 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. How to set up the steps for creating code
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 03-13-2015, 02:01 PM
  2. [SOLVED] How to prevent worksheet code from running while Module Macro is running:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 09:26 AM
  3. problem with how if insert copy paste working steps of macros when using VBA code
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2013, 04:23 AM
  4. [SOLVED] Modification help to swap steps in a code
    By VKS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2013, 07:27 AM
  5. Macro to hide/unhide cells not running or running slow
    By mbp727 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 04:22 PM
  6. VBA code to repeat steps in Macro
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 50
    Last Post: 08-22-2012, 09:44 AM
  7. Clean Up Code - consolidate steps
    By Frantic Excel-er in forum Excel General
    Replies: 6
    Last Post: 06-30-2005, 11:05 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