Formating cells within a secured worksheet
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Formating cells within a secured worksheet

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi all,
    I've got a worksheet which is secured with a password. Some cells are unlocked so that users can enter values. These values need to be highlighted somehow (bold or colored) so that we can easily see that they have been updated. Is this possible without unprotecting the worksheet? Thanks in advance for your help.
    Fred.

  2. #2
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You need to run an un-lock around your code.

    Try using the code below.

    put form buttons on the sheet to lock and unlock, the password is hardcoded into the VBA code and hidden. This way the user cannot change the password.

    This code gos on the sheet module:

    Private Sub Worksheet_Change(ByVal Target As Range)
    '
    ' Macro by Joseph S. Was
    '
    Application.EnableEvents = False

    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="admin"
    Application.EnableEvents = True
    End Sub

    This code gos on the module:

    Sub myUnLock()
    'This code will unprotect the sheet.
    Application.EnableEvents = False
    Application.DisplayAlerts = False
    ActiveSheet.Unprotect ("admin")

    'Add optional code here!

    Application.EnableEvents = True
    Application.DisplayAlerts = True

    End Sub

    This is a very simple form of this.
    If this is the route you want to try, I have some very complex systems?

    Note: The password is hard-coded.

    The unprotect will automatically be re-protected by the first macro when the unprotect is done.

    I do not know of a way to do it without the password. JSW


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com