Protection Macro
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Protection Macro

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

    Default

     
    I have a macro that protects all my worksheets. I have one tab that I unlocked some cells so that when it is protected the user can alter the contents. But everytime I protect the document using the macro the cells become locked again.

    Do I have to write in the macro to unlock those cells prior to protecting it?

    I have unlocked them, saved it. Then protected and it works, but if I use the macro to protect, then close the workbook and reopen the cells are locked again.

    Help!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    best advice i can offer

    follw what you wopuld do manulally tyo get the task automated, no shorts cuts VBA dont always shor cut just does what we can in 10 mins in 10 seconds VERY FAST..
    suggest record it.. watch errors them recored as well
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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