Combining separate button functions into one toggle button 2011 office for mac

Hello,

I have built a spreadsheet with a "start" button and a "stop" button that places a timestamp in a column for start time and a column for stop time.
All im wanting to do is combine these buttons into a toggle button that will display "start" and once clicked display "stop" and carry out the functions i've set the individual buttons to do already.

Im not sure if i need to use a certain type of button or wether i need to use active x (ive read this somewhere but have no idea how to access it)

I am using 2011 office for mac if that makes a difference.

Here is what i have already
Any help is much appreaciated.

TIMESHEET.xlsm

Hi Jeff!

Thank you for your quick response!

Theoretically should this be functional now or is there something i need to change?
The reason i ask is because it will not let me press the button.

Maybe active x controls are not compatible with mac ?

Originally Posted by Kaper

Or try your own procedure (and form button - not ActiveX control) - only slightly modified:

Please Login or Register  to view this content.

(Also not Mac tested).

oh yeaaah!
That's finally working!

Thanks a lot both of you, this will save my company so much time and effort, very much appreciated

Having said that when i re-save the file it stops the macros working, do i need to save it with a different file type or something?

You started with a .xlsm file type and that is what you need. This should work just the same as your original. Do you still have macros enabled?

Thanks, i figured it out, i was trying to save the file as '**timesheet' in order to keep it at the top in our folder but excel didnt like it.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.