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