Results 1 to 5 of 5

Only edit selected Sheets in workbook

Threaded View

rose8693 Only edit selected Sheets in... 08-20-2021, 11:00 AM
NoSparks Re: Only edit selected Sheets... 08-20-2021, 11:50 AM
rose8693 Re: Only edit selected Sheets... 08-20-2021, 01:09 PM
jolivanes Re: Only edit selected Sheets... 08-20-2021, 12:47 PM
jolivanes Re: Only edit selected Sheets... 08-20-2021, 01:16 PM
  1. #1
    Registered User
    Join Date
    04-10-2019
    Location
    VA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Question Only edit selected Sheets in workbook

    I'm designing a schedule and I need to set it up so that when I update the workbook only those sheets that need to be updated have the code run on them.
    Each sheet in the workbook is a month, so if I'm making changes in August I don't need the last 7 months updated, just the remaining 4.

    Right now my Macro updates all the sheets, unless I go in an remove their names from the array, which I don't want to do.

    I know I could probably do this with a checkbox, but honestly I just can't seem to wrap my head around the userforms or active controls. I know enough to assign a macro to a button, which I've already done to run my code and update my sheets.

    Can someone please help me with this and if possible explain how you did it.

    Thank you.
    Attached Files Attached Files
    Last edited by rose8693; 08-20-2021 at 01:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 06-05-2021, 03:23 AM
  2. Export Workbook into a New Workbook with Selected Sheets
    By vikas_newports in forum Excel General
    Replies: 1
    Last Post: 09-07-2018, 03:25 PM
  3. Edit listbox selected items and save to workbook???
    By madforit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 08:00 AM
  4. Replies: 3
    Last Post: 06-14-2007, 08:26 AM
  5. Replies: 6
    Last Post: 03-29-2006, 07:50 AM
  6. Replies: 6
    Last Post: 03-29-2006, 07:50 AM
  7. Replies: 6
    Last Post: 03-29-2006, 07:50 AM

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