+ Reply to Thread
Results 1 to 15 of 15

Delete schedule with the activity

  1. #1
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Delete schedule with the activity

    Good morning, as you can define in a macro the deletion of a schedule with the activity. I was thinking that instead of erasing the schedule I could replace it by putting an abbreviation in the example KTCH. I attach an example.
    Attached Files Attached Files
    Last edited by sprit36; 06-28-2017 at 04:26 AM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: Delete schedule with the activity

    Here's one way
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Delete schedule with the activity

    Try
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    And if in sheet 2 people are defined who should delete the schedule that change would have to do. Attached example. Thank you.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Delete schedule with the activity

    If this is not how you want, upload a workbook with your desired result.
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    Thank you, it's perfect. The only thing that would be missing is if the schedule is empty because it is a Sunday or has written vacations, do not write it. Thank you very much for the help.

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Delete schedule with the activity

    I don't understand what you are trying to do.

  8. #8
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    In the attached example, the days that do not work are blank, if you type in those days it seems that you are working, or if you have holidays you do not have to type in those cells. In blank cells or in those with text. Thank you.
    Attached Files Attached Files

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Delete schedule with the activity

    Still not sure
    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    Very well, it works very well. Thank you very much.

  11. #11
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    One question, when there is a lot of data and the macro runs, deforms and stretches the command buttons. How can it be solved? Thank you.

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Delete schedule with the activity

    Command buttons?

    Are they ActiveX or AutoShape or Forms button?

  13. #13
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    I try with autoshape and form button.

  14. #14
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Delete schedule with the activity

    If autoshape, right click on the shape, Properties, Object positioning, tick [Don't move or size with cells]

  15. #15
    Forum Contributor
    Join Date
    05-16-2017
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    103

    Re: Delete schedule with the activity

    I had the options activated on the button, but it kept happening. I have already solved. Thank you.

+ 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. Tiered Interest Schedule and Loan Amortization Schedule
    By wh1968mbz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2015, 07:43 AM
  2. Activity Time Tracker to capture activity selected from dropdown list
    By dillibabu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2013, 01:10 PM
  3. Replies: 8
    Last Post: 07-15-2013, 07:13 PM
  4. Updating a Schedule based on a master schedule
    By Lukerich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2013, 12:18 PM
  5. create daily schedule using master task schedule
    By DCO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 01:08 PM
  6. Replies: 0
    Last Post: 09-03-2010, 05:36 AM
  7. Replies: 8
    Last Post: 10-12-2005, 12:05 AM

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