Greetings:

How do I view the code for a built-in macro? Specifically, I want to see
the code for "next sheet" and "previous sheet" (Crtl-PageUp & Ctrl-PageDown

Thanks in advance for your help.
--
Barry Carroll

(Cleverly disguised as a responsible adult)
---------
PSC Scanning, Inc. assumes no responsibility whatsoever for any statements
made by me. I''m entirely on my own.

If you are asking to view Excel's built-in commands code, you are out of luck.

Those are not macros, but written in whatever programming language the
developers use.


Gord Dibben MS Excel MVP


Fri, 17 Nov 2006 13:48:01 -0800, Barry wrote:

Greetings:

How do I view the code for a built-in macro? Specifically, I want to see
the code for "next sheet" and "previous sheet" (Crtl-PageUp & Ctrl-PageDown

Thanks in advance for your help.

Gord:

Well, that's a disappointment. Thank you for the quick reply.

Best regards,

Barry Carroll

(Cleverly disguised as a responsible adult)
---------
PSC Scanning, Inc. assumes no responsibility whatsoever for any statements
made by me. I''m entirely on my own.


"Gord Dibben" wrote:

If you are asking to view Excel's built-in commands code, you are out of luck.

Those are not macros, but written in whatever programming language the
developers use.


Gord Dibben MS Excel MVP


Fri, 17 Nov 2006 13:48:01 -0800, Barry wrote:

Greetings:

How do I view the code for a built-in macro? Specifically, I want to see
the code for "next sheet" and "previous sheet" (Crtl-PageUp & Ctrl-PageDown

Thanks in advance for your help.

Hi,

Not sure if this is what you mean.

Turn on the macro recorder and do the action. For me it spat out this code.

ActiveSheet.Next.Select

But if you want MS actual code, then as Gord said, your out of luck.

Cheers
Andy

Barry wrote:
Greetings:

How do I view the code for a built-in macro? Specifically, I want to see
the code for "next sheet" and "previous sheet" (Crtl-PageUp & Ctrl-PageDown

Thanks in advance for your help.

Public Sub Standards()
'Standards Dates
ActiveSheet.Unprotect
Workbooks.Open Filename:="\Emerald
Calibrations\ECEquip\LabM\StandardsM.xls"
Continue
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Private Sub Continue()
'Copy, Cut, and Paste (Standards Dates)
Range("TE1.3:TN1.3").Select
Selection.Copy
ActiveWindow.ActivateNext
Range("TE1.1:TN1.1").Select
ActiveSheet.Paste
ActiveWindow.ActivatePrevious
Application.CutCopyMode = False
ActiveWindow.Close
End Sub

The above contains an example what I think you want. It opens a workbook
that contains test equipment data that is copied and pasted into a second
workbook, the first workbook is then closed. It works regardless of the name
of the second workbook and I only need update calibration and recall dates on
one workbook to keep them all current.
HTH
Lou


"Andy Pope" wrote:

Hi,

Not sure if this is what you mean.

Turn on the macro recorder and do the action. For me it spat out this code.

ActiveSheet.Next.Select

But if you want MS actual code, then as Gord said, your out of luck.

Cheers
Andy

Barry wrote:
Greetings:

How do I view the code for a built-in macro? Specifically, I want to see
the code for "next sheet" and "previous sheet" (Crtl-PageUp & Ctrl-PageDown

Thanks in advance for your help.