running code
From: mark (anonymous_at_discussions.microsoft.com)
Date: 03/12/05
- Next message: Nick Hodge: "Re: running code"
- Previous message: Paul B: "Re: Deselecting unwanted cells"
- Next in thread: Nick Hodge: "Re: running code"
- Reply: Nick Hodge: "Re: running code"
- Reply: JulieD: "Re: running code"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 12 Mar 2005 07:07:02 -0800
I have the following code in my workbook, how can I use a
command button to run this.
Private Sub Workbook_Open()
Dim wb As Workbook
'copy all sheets
Worksheets.Copy
Set wb = ActiveWorkbook
Application.DisplayAlerts = False
'delete the sheets you want
wb.Sheets(Array("Suspense", "RCA exc RIM", "Operations
summary", "RCA incl RIM", "First Qtr", "Second
Qtr", "Third Qtr", "Fourth Qtr")).Delete
Application.DisplayAlerts = True
End Sub
any help please
Mark
- Next message: Nick Hodge: "Re: running code"
- Previous message: Paul B: "Re: Deselecting unwanted cells"
- Next in thread: Nick Hodge: "Re: running code"
- Reply: Nick Hodge: "Re: running code"
- Reply: JulieD: "Re: running code"
- Messages sorted by: [ date ] [ thread ]