Button to place a time stamp, save the file, and exit

I have a work center accountability tool and would like to assign a macro to a shape so that when it is clicked it will:

Put a timestamp into a specific cell
update all the formulas in the file
save and check in the file in its current place (SharePoint)(it must be checked out to edit)
then close the file.

I already have the shape, and the location for the time stamp (having trouble with getting the macro to focus on a specific cell and not the active cell)

I am really new to macros and am learning by doing. Any help would be greatly appreciated.

Taiter

Hi Taiter

Can you post your current code? (Make sure to encapsulate it by selecting it here and pressing the # button above).

As for the ActiveCell, you can change that to Sheet1.Range("A1") or whatever cell you want.

Thanks
Duncan

OK, if you know which cell you want to place it in, you can just replace the line with ActiveCell with

Please Login or Register  to view this content.

If you want it in A2 in Sheet1.

As for saving and checking in, try:

Please Login or Register  to view this content.

at the end of your code.

Thanks
Duncan

Do I have to change the "Sheet1" to be active sheet so that when I copy and rename the sheet it will continue to work on just that sheet?

It will continue to work on that sheet if the sheet is not active.

If you want it only on the active sheet, you can use:

Please Login or Register  to view this content.

It still places the stamp in the active cell. I need it to show the result in cell C6 regardless which cell is active.

This is what I have now:

Please Login or Register  to view this content.

What am I missing?

Thank you for your assistance.

You are setting the active cell's value to DT afterwards, you want to remove this line:

Please Login or Register  to view this content.

Also you need to change the Selection.NumberFormat line to:

Please Login or Register  to view this content.

Thank you! It has been a huge help.