LinkBack URL
About LinkBacks
I haven't worked with shared workbooks, but there seems to be many disucssions in this forum. Search for "macro shared workbook"
I haven't worked with shared workbooks, but there seems to be many disucssions in this forum. Search for "macro shared workbook"
FrankBoston is the pen name for Andrew Garland, Lexington MA
Unfortunatly not. It's looking like their might not be away around this.
I created a macro in a workbook with a button that
Pastes the username, Pastes the time they punched in and a formula that shows the Employee's Name and Supervisors Name.
My dream would be a workbook that would update almost in realtime that shows when users Punch In and Punch Out and in a shared workbook.
My problem is that excel doesn't allow macros in a shared workbook.
Does anyone know of any way to do a timeclock like this?
Nate
What version of Excel are you using?
I have built workbooks with Macros that have been shared.
You need to remove the Share option for the workbook.
Build your macro
Share Workbook
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
I'm using Excel 2003. I'd like to have a timeclock that is in almost realtime so it keeps refreshing and saves after someone punchs in.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks