VBA Code to Add Worksheet to Workbooks that Split
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: VBA Code to Add Worksheet to Workbooks that Split

  1. #11
    New Member
    Join Date
    Jul 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Code to Add Worksheet to Workbooks that Split

    Hi!

    Do you know if there is also a way to Password Protect the workbook upon opening into all of the sheets that split? When I password protect the original workbook and split them, the sheets that split do not require a password to open them.

    Any help would be greatly appreciated, thank you so much!

  2. #12
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,897
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: VBA Code to Add Worksheet to Workbooks that Split

    I've never used password protection at workbook level.
    Best bet is to record a macro of you adding a password when you save the workbook. That should then give you the code you need
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #13
    New Member
    Join Date
    Jul 2019
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA Code to Add Worksheet to Workbooks that Split

    Hi! Unfortunately that did not work, I found some short one-line codes online to password protect a workbook in VBA, but i'm not sure where to place it within my code to get it to work. I will keep looking, thank you for your help!

Some videos you may like

User Tag List

Tags for this Thread

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
  •