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/calcul...n-schedule.htm

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

Cordially,
Ryan---

--
RyGuy

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


On Tue, 18 Dec 2007 16:10:05 -0800, ryguy7272
wrote:

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/calcul...n-schedule.htm

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

Cordially,
Ryan---

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" wrote in message
...
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/calcul...n-schedule.htm

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

Cordially,
Ryan---

--
RyGuy

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


--
RyGuy


"Bob Phillips" wrote:

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" wrote in message
...
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/calcul...n-schedule.htm

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

Cordially,
Ryan---

--
RyGuy

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 wrote:

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

--
RyGuy

"Bob Phillips" wrote:

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" wrote in message
...
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/calcul...n-schedule.htm

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

Cordially,
Ryan---

--
RyGuy




--

Dave Peterson

Dave, you are right!! I never use protection on my worksheets and I didnt
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---



--
RyGuy


"Dave Peterson" wrote:

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 wrote:

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

--
RyGuy

"Bob Phillips" wrote:

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" wrote in message
...
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/calcul...n-schedule.htm

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

Cordially,
Ryan---

--
RyGuy




--

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.



ryguy7272 wrote:

Dave, you are right!! I never use protection on my worksheets and I didnt
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---

--
RyGuy

"Dave Peterson" wrote:

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 wrote:

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

--
RyGuy

"Bob Phillips" wrote:

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" wrote in message
...
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/calcul...n-schedule.htm

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

Cordially,
Ryan---

--
RyGuy




--

Dave Peterson


--

Dave Peterson