Merging VBA into one.

**sambo24** · 06-19-2013, 10:23 AM

Please help

Here is my code, I need it all to run under one single keyboard shortcut, currently I have to do 2.

Please Login or Register  to view this content.

Can anyone assist?

**duncandhu** · 06-19-2013, 10:25 AM

At the end of Sub TimeSheet(), put

Please Login or Register  to view this content.

just before

Please Login or Register  to view this content.

What this does is calls the SaveAsA1 from inside TimeSheet.

Thanks,
Duncan

**arlu1201** · 06-19-2013, 10:33 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.