Viewing Built-in Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barry - 17 Nov 2006 21:48 GMT

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.

Signature

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.

Reply to this Message

Gord Dibben - 17 Nov 2006 22:21 GMT

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

>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.

Reply to this Message

Barry - 17 Nov 2006 22:33 GMT

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.

> If you are asking to view Excel's built-in commands code, you are out of luck.
>
[quoted text clipped - 9 lines]
> >
> >Thanks in advance for your help.

Reply to this Message

Andy Pope - 18 Nov 2006 10:21 GMT

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

> 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.

Reply to this Message

Rookie 1st class - 19 Nov 2006 23:14 GMT

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

> Hi,
>
[quoted text clipped - 15 lines]
> >
> > Thanks in advance for your help.

Reply to this Message