+ Reply to Thread
Results 1 to 3 of 3

How to fix runtime error 70 permission denied ?

  1. #1
    Registered User
    Join Date
    01-04-2017
    Location
    Washington
    MS-Off Ver
    365
    Posts
    3

    How to fix runtime error 70 permission denied ?

    I have a proposal log I keep. I started a new one for this year, and added a Userform. However, when Itry to run it I get an error.

    I had the same userform before, just added more columns to the worksheet. I thought maybe it would work.

    I dont' know what a runtime error 70 is exactly, but from what I've read I maybe trying to access too many rows/columns in a range. I have 5 ranges/lists in this userform I'm using. One has about 130 names, the others are quite smaller. Iv'e checked the names.

    See the code below.

    VBAPic.png

    here is the code:

    Please Login or Register  to view this content.


    Any Ideas ??

    Tony
    Last edited by FDibbins; 01-05-2017 at 02:12 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,758

    Re: How to fix runtime error 70 permission denied ?

    Welcome to the forum!

    Unfortunately, your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: How to fix runtime error 70 permission denied ?

    I have added the code tags for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 07-24-2014, 08:59 PM
  2. Runtime Error 70 - Permission Denied - Iframe - IE10 - Excel VBA
    By VBATOexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2013, 06:20 PM
  3. Run time error 70 Permission denied.
    By sagar.rajula in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2013, 11:50 AM
  4. Exporting picture. Runtime-Error 70 permission denied. Work-around?
    By Taktiker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2012, 03:57 PM
  5. RunTime 70 Error - Permission Denied
    By ross88guy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2011, 04:46 AM
  6. [SOLVED] error 70 - Permission denied
    By MT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2005, 03:06 AM
  7. Run-time error '70': Permission denied
    By Maury Markowitz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2005, 05:06 PM

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