Running a Macro Without Apparent Code

[ryguy7272]

I found a file on the web today and looked to see what the macro was like to
learn from it. There is some event code and a tiny in the SS. When I
deleted all the code, the SS was still automated. How can an Excel SS be
automated without any apparent macros?

This is the file:
http://www.studentloansed.com/calculators/student-loan-amortization-schedule.htm

I'd appreciate it if anyone can tell me how it runs without the code!!

Cordially,
Ryan---

 

[Gord Dibben]

You won't learn much from the VBA in that workbook

There is no automation involved except for the formulas in the sheet.

There is no sheet event code in that workbook but some useless lines in the
sheet which you could delete

There is a print preview macro in Module1

If you deleted that macro without deleting Module1 you will still get the macro
warning if that's what you are referring to.

If you want to learn about working with and creating macros see David
McRitchie's "getting started with VBA and macros"

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Gord Dibben MS Excel MVP

 

[Bob Phillips]

See http://www.contextures.com/xlfaqMac.html#NoMacros

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ryguy7272]

Thanks guys. What I'm asking is...what makes the SS from that site
automated? I can't see what makes it run... When you enter values into the
yellow cells, what makes the pink cells populate? What makes the
amortization table populate? I can't see any code anywhere!!

Thanks,
Ryan--

 

[Dave Peterson]

I bet it just uses formulas.

If the worksheet is protected, you can hide any formula in a locked cell.

In xl2003,
Format|cells|Protection tab
check locked and hidden

Then when the worksheet is protected, you don't get to see the formula in the
formula bar for those cells.

 

[ryguy7272]

Dave, you are right!! I never use protection on my worksheets and I didn’t
know that formulas are actually hidden in locked cells. When I didn't see
any formulas on the sheet, I automatically thought it was some kind of event
code, but no code was revealed when I right-clicked the tab.

Thanks!!
Ryan---

 

[Dave Peterson]

For me, I don't usually protect worksheets with a password. (There are too many
resources that will break the password.)

But I do protect worksheets with no passwords--it makes it harder for the user
(me!) to screw up formulas.