Results 1 to 6 of 6

Protect sheet button is not working

Threaded View

Sophster Protect sheet button is not... 03-23-2011, 06:22 AM
pike Re: Protect sheet button is... 03-23-2011, 06:26 AM
Roger Govier Re: Protect sheet button is... 03-23-2011, 06:27 AM
Sophster Re: Protect sheet button is... 03-23-2011, 06:42 AM
royUK Re: Protect sheet button is... 03-23-2011, 07:32 AM
Sophster Re: Protect sheet button is... 03-23-2011, 07:35 AM
  1. #1
    Registered User
    Join Date
    12-14-2010
    Location
    London , England
    MS-Off Ver
    Excel 2007
    Posts
    40

    Question Protect sheet button is not working

    I have created a button with the below assigned macro so that when the button is clicked, the whole spreasheet freezes.
    This works with the below code but the issue is that anyone can click on the review tab and unprotect sheet. the worksheet will then unlock without requesting the password, whereas it requests the password without the macro.

    Is there a way to fix the code so that anyone clicking on "unprotect sheet" will be prompted to enter the password. Any help would be greatly appreciated.! Thanks very much!

    Sub ProtectSheet()
    
        ActiveCell.Cells.Select
        ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
        ActiveSheet.EnableSelection = xlNoSelection
    End Sub
    Last edited by Sophster; 03-23-2011 at 07:35 AM. Reason: add code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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