+ Reply to Thread
Results 1 to 9 of 9

VBA code is read-only - how do I copy it?

  1. #1
    Registered User
    Join Date
    04-04-2019
    Location
    Madrid
    MS-Off Ver
    2013
    Posts
    5

    VBA code is read-only - how do I copy it?

    Hi there,

    I have to adapt an old VBA powerpoint code for work but the issue is that its in read-only.
    If I copy the code and try to paste into another module or Word/notepad, nothing shows up (and when pasting to another module it crashes the powerpoint)
    Worst comes to worst I could type it out but itīs very long so I was looking for a smarter solution.

    Many thanks!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,945

    Re: VBA code is read-only - how do I copy it?

    Thread moved to appropriate section.

    Why is the code read-only? Are you trying to copy commercial code?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    04-04-2019
    Location
    Madrid
    MS-Off Ver
    2013
    Posts
    5

    Re: VBA code is read-only - how do I copy it?

    It was created by someone else in the same company who has since left and we are unable to contact, I imagine he chose to protect it.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,945

    Re: VBA code is read-only - how do I copy it?

    OK - so please attach the PowerPoint file.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  5. #5
    Registered User
    Join Date
    04-04-2019
    Location
    Madrid
    MS-Off Ver
    2013
    Posts
    5

    Re: VBA code is read-only - how do I copy it?

    Is there no way to get assistance without attaching the document? For privacy purposes?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,945

    Re: VBA code is read-only - how do I copy it?

    Remove the sensitive information first. How do you expect us to be able to help you to get the VBA code without access to it?

  7. #7
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,964

    Re: VBA code is read-only - how do I copy it?

    I imagine he chose to protect it.
    The way I read this is that you're asking use to break Forum Rule#7 regarding bypassing Security Options.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,945

    Re: VBA code is read-only - how do I copy it?

    I don't think so, Rudi - the workbook is the company's property as the former employee created it whilst working for them for use in the business. I believe we can give this the benefit of the doubt.

  9. #9
    Registered User
    Join Date
    05-11-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Re: VBA code is read-only - how do I copy it?

    got it. thanks
    Danish is working with It Training Centers.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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