+ Reply to Thread
Results 1 to 3 of 3

How to Restrict user to insert macro in my locked excel file.

  1. #1
    Registered User
    Join Date
    07-04-2014
    Location
    Pune, India
    MS-Off Ver
    2016 & 365
    Posts
    18

    Question How to Restrict user to insert macro in my locked excel file.

    I have created an excel file and protected with password.
    i also want to restrict user from inserting VBA code by using Alt+F11 key.

    Please help as soon as possible....

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: How to Restrict user to insert macro in my locked excel file.

    Hi
    Follow these stepas and add a password to your VBA module. That way no one should be able to add codce to your workbook:
    > Open excel
    > open your workbook
    > hit alt-f11 (to get to the vbe)
    > hit ctrl-r (to see the project explorer)
    > with your project selected in the project explorer
    > Tools VBAProject Properties
    > Protection tab.
    Hope this helps.
    Tony

  3. #3
    Registered User
    Join Date
    07-04-2014
    Location
    Pune, India
    MS-Off Ver
    2016 & 365
    Posts
    18

    Re: How to Restrict user to insert macro in my locked excel file.

    Thank you very much.
    Its awesome dude..

+ 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. Replies: 0
    Last Post: 03-15-2013, 08:16 AM
  2. Excel file was locked by another user.
    By jdlc in forum Excel General
    Replies: 1
    Last Post: 10-30-2012, 03:28 PM
  3. Notify user that a file is locked upon running insert/update query
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2012, 04:59 PM
  4. restrict a user from opening a dbf file from excel?
    By WyldX in forum Excel General
    Replies: 0
    Last Post: 01-18-2006, 09:45 AM
  5. Replies: 1
    Last Post: 01-06-2005, 10:06 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