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.
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.
Last edited by sprit36; 06-28-2017 at 04:26 AM.
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!!!
Try
Please Login or Register to view this content.
And if in sheet 2 people are defined who should delete the schedule that change would have to do. Attached example. Thank you.
If this is not how you want, upload a workbook with your desired result.
Please Login or Register to view this content.
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.
I don't understand what you are trying to do.
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.
Still not sure
Please Login or Register to view this content.
Very well, it works very well. Thank you very much.
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.
Command buttons?
Are they ActiveX or AutoShape or Forms button?
I try with autoshape and form button.
If autoshape, right click on the shape, Properties, Object positioning, tick [Don't move or size with cells]
I had the options activated on the button, but it kept happening. I have already solved. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks