Save workbook after removing dropdown access

  • Hello all

    i have a workbook with 150 different locations, these locations are in a dropdown list. as you select locations the table below changes showing the wages etc (works using lookups)

    i need a macro that will

    - move through the workbooks 1-150 and save them in set location

    - MUST disallow dropdown in C2 after saving - wages etc are shown in the table once the location is selected .

    currently these are all on 1 workbook.

    need 150 workbooks


  • thanks so much

  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


  • update ------ the code attached works fine, it goes through all locations and saves as needed

    however these 150 locations (files) now have to be sent to the managers. we do not want them to be able to select the dropdown in C2 once its been saved and sent. (so they can see other location cash)

    i can get the dropdown to disable but then the code stops running through as it is set to run through the dropdown in C2 until the end

    all i need is once its saved to disallow the dropdown in C2


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!