+ Reply to Thread
Results 1 to 8 of 8

Permission Denied Error Trying To Define A List For A Combobox

  1. #1
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Permission Denied Error Trying To Define A List For A Combobox

    Is anyone able to help me with this code?

    Please Login or Register  to view this content.
    I am trying to create a list from a range for a combox (rate_code).
    The line in red is giving me a "Permission denied." error.
    Last edited by AliGW; 04-07-2019 at 04:32 PM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Permission Denied Error Trying To Define A List For A Combobox

    You’ve set the rowsouce in the properties menu, you need to remove it. You can’t use rowsource and list

  3. #3
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Permission Denied Error Trying To Define A List For A Combobox

    That was my first thought also Kyle, but that's not it ...

    Attachment 619106

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Permission Denied Error Trying To Define A List For A Combobox

    .
    Your attachment is invalid. Try again.

  5. #5
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Permission Denied Error Trying To Define A List For A Combobox

    I had no problem opening the photo, but here it is again.

    Attachment 619108

    It just simply shows that the RpwSource property is empty.

  6. #6
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Permission Denied Error Trying To Define A List For A Combobox

    If I comment out this line, my "rate_code" combobox's listsource is an old list used earlier in my code. I guess this this error comes when the .list is already created. If that the case, and I need a new list source, how do I get rid of the old one first?

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Permission Denied Error Trying To Define A List For A Combobox

    .
    I'm thinking you can see your attachment as the image is probably also located on your computer.
    The new link does not work either.

    Keep in mind that pics are ok but not very informative. The best approach is to attach a copy of your workbook, less and confidential information.
    To attach a workbook you will need to use the "GO ADVANCED" button.

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,886

    Re: Permission Denied Error Trying To Define A List For A Combobox

    Perhaps you assigned it elsewhere in code. Does this work?

    Please Login or Register  to view this content.
    Rory

+ 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. getting error 70 permission denied on userform
    By kevinu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-02-2019, 02:38 AM
  2. How to fix runtime error 70 permission denied ?
    By TR16238 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-05-2017, 02:13 AM
  3. Run-time error '70': Permission denied
    By Arvin.Amaro in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-09-2015, 08:24 AM
  4. [SOLVED] Error 70 'Permission Denied' when Pasting
    By Contigo1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-05-2013, 03:46 AM
  5. 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
  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

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