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