Results 1 to 12 of 12

Prevent user from running private macros

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2014
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    13

    Post Prevent user from running private macros

    Hi,

    I have a workbook with several sheets and a lot of macros.

    I have protected the VBA project and also the sheets and all the macros are private.

    What I'm wondering is if there's a way to prevent users from unintentionally run macros
    from the macro menu (Alt + F8). I know that if the macros are private they wil not show
    in this menu, but if a macro is named "A" and someone type "A" in the macro meny they will be able to run it.

    I need macros to be run on the right sheet only, else it can delete other codes on the sheet.

    Hope someone can help me out here


    Thomas
    Last edited by trimmjens; 11-26-2014 at 06:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Prevent macros running after message box show
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2013, 01:09 AM
  2. Prevent two macros from running at the same time
    By Kreef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 10:36 PM
  3. Prevent private sub macro from running
    By jman0707 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-15-2008, 01:35 AM
  4. Prevent a user from running a macro
    By vbace2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2006, 11:28 PM
  5. [SOLVED] Prevent others from running my macros
    By Frederick Chow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2005, 02:10 PM

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