+ Reply to Thread
Results 1 to 2 of 2

Running macros on protected work sheets

  1. #1
    Registered User
    Join Date
    03-15-2012
    Location
    Liverpool
    MS-Off Ver
    Excel 2013
    Posts
    58

    Running macros on protected work sheets

    Hello

    Could I have the most simplest code to allow macros to run on protected worksheets (all have the same password).


    I would also be interest in the code to use which will allow the macro to run without the need to make the password visible within the macro.

    Kind regards

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,330

    Re: Running macros on protected work sheets

    Checkout the Protect method and espescially the UserInterfaceOnly argument.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Running Macros when worksheets are protected
    By cbrow236 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-17-2013, 09:43 AM
  2. Macros stop to work when work sheet is protected. Run time error 1004
    By sellim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2012, 01:14 AM
  3. [SOLVED] Running macros with protected sheets
    By RebeccaEllis in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 08-07-2012, 05:01 PM
  4. [SOLVED] Excel 2007 : Running Macros on Protected Sheets
    By ExcelNewbie2534 in forum Excel General
    Replies: 5
    Last Post: 04-16-2012, 07:36 PM
  5. running macros on protected sheets
    By baz0912 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2008, 08:12 AM
  6. running macros on protected sheets
    By baz0912 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2008, 05:11 AM
  7. Macros not running frm protected project.
    By Aussie_Striker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2007, 07:39 AM
  8. Replies: 1
    Last Post: 09-19-2006, 02:02 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