Viewing Built-in Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Best regards,

Barry Carroll

(Cleverly disguised as a responsible adult)
 
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
 
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
 
Back
Top