Search results for query: *

I have 2 workbooks. I need a macro that when activated in workbook1, it will take you to workbook2 with its own path in a [highlight #FCE94F]NEW instance[/highlight] and at the same time will close and save workbook1.

The following is the VBA code I am using for date and time in Target.Row, 7. What would need to be changed in it to subtract 1 hour from the now time: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Cells(5, "B").EntireColumn) Is Nothing Then...

Thanks, and you are correct. Do not know what I was thinking. I meant eastern time instead of pacific time. Yes, will need to include the date as well to keep things straight.

Our computers are controlled by a central server on pacific time which is lock down and we can not change. . We are on central time which is a one hour difference. When we make spread sheets in excel, is always looks at the system time to calculate dates and time, which are incorrect for our...

The original was place into the Microsoft excel objects in the "ThisWorkbook". Was enter as a Private Sub Workbook_Open(), which is where you place the Resetinout micro. Stated I could only have one Workbook Open() micro. Was not sure how to enter it a different way.

OK, thought we were done, but came across one last problem. When we did the IN/out reset above, the macro for hiding all toolbars was in conflict and had to be disabled. Have tried some other ways of getting that to work by using the modules field, however, nothing has worked so far. Is their a...

Thank you for the help. Was not sure how to do the structure table, but I finally figured it out. Some of this was really new to me. Again a big thx....

Really appreciate your help. Evidently, I am amiss of something. I place the micro into our spreadsheet that we will be using and am getting an error. I attached the actually file that is currently being used, could you please check it for me and correct it, then maybe I can see what I did...

That is correct, that would work perfect for us.....

I currently have a spreadsheet that is used as a check in/out board at work. Attaching a small sample of it. What I want to do is for all persons that are currently checked in thru a dropdown box, and forget to check out at the end of the day, a macro could be set up to run and reset all of the...

Have created a In and Out board for our employees. They are required to check in and out and it also has the options of vacations, remote, sick, etc. Some employees who are checked in forget to check out at the end of the day or can not for various reasons. Would like a VBA micro that for...

Have a spreadsheet with dropdown menu for rows 1 through 10, which include the choice's of "in, out, remote, etc. The dropdown menu will be in A2. B2 & C2 are open for typing in locations, etc. What I would like to do is when the choice in the dropdown menu in A2 is either In or OUT, then cells...