Posted to microsoft.public.excel.programming

Ewing25

external usenet poster

Posts: 62

automatic macro

awesome thank you!

"Ewing25" wrote:

How do I make it so my code runs everytime I click on a certain worksheet.

This is my code so far.

Sub TripsCopy()
Dim Trips As Integer
Dim tr As Integer

Active.Sheet (Expense)
Trips = InputBox("Enter Number of Trips Taken")
If Trips 1 Then
'Sheets("Individual Trip").Select
For tr = 1 To Trips
Sheets("Individual Trip").Copy After:=Sheets(Sheets.Count)
Next
End If
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic run of Macro	Frank	Excel Discussion (Misc queries)	1	February 21st 07 03:10 PM
Automatic run of Macro	Tom Ogilvy	Excel Discussion (Misc queries)	0	February 21st 07 02:33 PM
Automatic Macro	Momo	Excel Programming	1	October 21st 04 12:01 PM
Automatic Macro in Excel	MMM[_2_]	Excel Programming	1	February 3rd 04 03:53 PM
Automatic Macro	ianripping[_3_]	Excel Programming	3	January 15th 04 05:22 PM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us