+ Reply to Thread
Results 1 to 3 of 3

Macro/VBA Buttons not working when sheet is password protected

  1. #1
    Registered User
    Join Date
    10-23-2015
    Location
    USA
    MS-Off Ver
    Windows MS office 2010
    Posts
    52

    Macro/VBA Buttons not working when sheet is password protected

    I have a sheet and the password to unprotect is "hoffstate". If you unprotect the sheet, the buttons for Full View and Plan/Forecast view give you custom views and it works. But the second the sheet is password protected, those buttons dont work anymore and it doesn't run.

    Can someone please give me a fix
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-23-2015
    Location
    USA
    MS-Off Ver
    Windows MS office 2010
    Posts
    52

    Re: Macro/VBA Buttons not working when sheet is password protected

    ............

  3. #3
    Registered User
    Join Date
    02-26-2016
    Location
    Wisconsin, USA
    MS-Off Ver
    2013, 2016
    Posts
    33

    Re: Macro/VBA Buttons not working when sheet is password protected

    You could change the code to this:

    Please Login or Register  to view this content.
    However, now your sheet protection password is visible in the Visual Basic Editor. You can protect the macro code with the same password by going to Tools->VBAProject Properties in the VBE and locking the project for viewing in the Protection tab.

+ 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. Macro for allowing access for users to click buttons when sheet is protected
    By targus92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2016, 12:29 PM
  2. How to unlock the password protected sheet using macro
    By Jeffri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2014, 07:25 AM
  3. How to run a macro in password protected sheet
    By leo73pk in forum Excel General
    Replies: 15
    Last Post: 06-14-2013, 05:33 AM
  4. [SOLVED] Need macro to open excel sheet that is password protected
    By sokker23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2013, 03:04 PM
  5. [SOLVED] Password protected macro from unused sheet I cant get rid of
    By MIACG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2013, 11:09 AM
  6. Running Macro in Password protected sheet in excel 2007
    By alla_ratnaji in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2012, 03:30 AM
  7. Excel 2007 : Running a Macro on a Password Protected Sheet
    By Martin Chamberlin in forum Excel General
    Replies: 1
    Last Post: 05-05-2011, 09:27 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