+ Reply to Thread
Results 1 to 3 of 3

Need to Enable Macro on Ready-made shape in a protected xlsm sheet

  1. #1
    Registered User
    Join Date
    05-24-2014
    Location
    Centralia, WA
    MS-Off Ver
    7
    Posts
    2

    Question Need to Enable Macro on Ready-made shape in a protected xlsm sheet

    Hello, thanks for reading this.

    I am making a budget for my household. Nothing extravagant, but I am the only one with budgeting skills and I want to make an easy to use form using Excel so my spouse can also use it. When he makes purchases, he is going to enter them into a column of deductions using a Macro I have recorded. I have locked the spreadsheet so he cannot accidentally remove any important numbers. I placed the macro on a ready-made shape so it acts like a button. Only problem is, after I locked the spreadsheet, it no longer works! I have attached a visual aid with the macro button circled and the unlocked items dotted in green. The error message that pops up reads, "The macro may not be available or this work book or all macros may be disabled." Since the sheet works fine when unlocked, I am assuming locking the sheet has been turning off the macros. Is there a way to run the macro while the sheet is locked?
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: Need to Enable Macro on Ready-made shape in a protected xlsm sheet

    Hi

    By using this trick, unprotect the sheet first then run your code then protect as you required.

    Please Login or Register  to view this content.
    Add below code at end of your codes

    Please Login or Register  to view this content.
    Regards,
    Joshi
    Last edited by krjoshi; 05-24-2014 at 05:25 PM.
    Cheers,

    Joshi
    Being with a winner makes you a winner

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need to Enable Macro on Ready-made shape in a protected xlsm sheet

    Is there a way to run the macro while the sheet is locked?
    Protecting the sheet shouldn't keep the macro from running when the shape is clicked. Can you put the workbook on box.net, stripped of all sensitive info, and post a link?
    Entia non sunt multiplicanda sine necessitate

+ 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: 2
    Last Post: 05-24-2014, 07:45 PM
  2. [SOLVED] bug on the macro coded sheet, a protected sheet, every time i made an action i wanted
    By dondonordas in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-22-2014, 06:46 AM
  3. Replies: 1
    Last Post: 02-22-2014, 01:28 AM
  4. Replies: 10
    Last Post: 11-22-2013, 04:58 AM
  5. Replies: 0
    Last Post: 10-10-2011, 06:56 PM

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