+ Reply to Thread
Results 1 to 3 of 3

Block Macros manual access on users

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Block Macros manual access on users

    Hello all,

    I have a macro that each user on entering has to enter his own user and password and lets him access his/her own sheets.

    Although i want to block access of macros besides the buttons shortcuts on their sheets.. is there a way to do that ?

    Basicly block the acess of the button "MACROS" on development tab

  2. #2
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Block Macros manual access on users

    Is it enough to write Private before Sub ? although i need to call macros from other macros... and call "MYMACRO" doesn't work
    Last edited by brainzlp; 02-06-2016 at 12:12 PM.

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    505

    Re: Block Macros manual access on users

    Option Private Module - THIS DOES THE TRICK, if anyone knows a better solution , let me know

+ 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. Cant hide worksheets after macros to force users to enable macros
    By Mboemoyo85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2015, 02:52 AM
  2. How to block access for Save as excel file in Same folder
    By Nisar.mohammed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2015, 09:51 AM
  3. Block access connections on DATA
    By ibbe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2014, 06:40 AM
  4. Need Help Please In restricting access to users in Access 2010
    By Sharath_rk in forum Access Tables & Databases
    Replies: 5
    Last Post: 02-01-2013, 09:05 AM
  5. [SOLVED] Complex macro? or Multiple macros? Manual? CHALLENGE!!
    By kamgrn in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-06-2012, 11:06 AM
  6. Macro to comment block other macros/subs
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2011, 12:50 PM
  7. Block users from typing in a combo box
    By bigpee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-23-2009, 11:19 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