+ Reply to Thread
Results 1 to 3 of 3

Drop-down width - why won't this VBA work on "complex" workbook?

  1. #1
    Registered User
    Join Date
    09-26-2017
    Location
    Sweden
    MS-Off Ver
    Office 2013
    Posts
    16

    Drop-down width - why won't this VBA work on "complex" workbook?

    in the attached file, I have used a VBA to adjust the width of drop-down list, even though the column is not as wide as the content of the drop-down list.

    It works fine. But when I try to apply this to a more complex workbook, it doesn't work. I cannot attach this workbook, due to sharing-restrictions. However, my question is, is there a reason why this VBA wouldn't work on more complex workbook. For example, it has protected sheets. Can that cause a problem?

    A bit annoying I cannot make it work - perhaps anyone has a better VBA to manipulate the drop-down list width?

    Thank you very much!
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Drop-down width - why won't this VBA work on "complex" workbook?

    I don't see any reason why a more complicated sheet would change how the VBA works unless the attributes of the sheet are different.

    Anyway, if the sheet is protected, you need to unprotect the sheet at the beginning of the code and then protect at the end.

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    09-26-2017
    Location
    Sweden
    MS-Off Ver
    Office 2013
    Posts
    16

    Re: Drop-down width - why won't this VBA work on "complex" workbook?

    jeffreybrown,

    Thank you for quick reply. Still, it doesn't work. Fyi, I don't know the first thing about VBA, I have just copied the code.

    But the sheet with the values for the drop-down list, should it have the same code in it as the other sheets (becasue there are 12 sheets I want to apply same logic to):

    What should this string look like for each sheet? And for sheet with the drop-down values?

    Please Login or Register  to view this content.
    Sorry if I'm not clear...
    Last edited by jeffreybrown; 11-08-2018 at 10:44 AM. Reason: Removed full quote!

+ 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. Fairly complex - matching "siblings" and "parents" across sheets
    By michael.sejrup in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-09-2016, 01:24 AM
  2. Replies: 3
    Last Post: 01-02-2014, 02:15 PM
  3. [SOLVED] Complex "if" "or" "else" statement for ABC analysis
    By TheDanee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 08:43 AM
  4. Complex IF functions containing "ISNA" and "VLOOKUP"
    By myshadeofglory in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2011, 03:28 PM
  5. [SOLVED] Do mighty exchange "pixels" on "mm" - cells (width, height)? :(
    By And1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2006, 08:15 AM
  6. Replies: 1
    Last Post: 01-30-2006, 06:10 PM
  7. XL2000 "Custon Views" "Column width" Problem
    By Des in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 10:05 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