Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have two macros. I would like to press 1 macro button that will do both
macros. Is there a way to do this? Macros are below, Joe Sub SaveAsCellString() ActiveWorkbook.SaveAs Filename:= _ "C:\shipway\invoices\" & Range("E5").Formula, FileFormat:=xlExcel9795, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub Sub clearform() ' ' clearform Macro ' Macro recorded 20/06/2005 by Joe Clarkson ' ' Range("A16:C28").Select Selection.ClearContents Range("E8").Select Selection.ClearContents End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |