My formulas/codes not working after I close and reopen the file.

[sbrazil]

Hi,
I am putting a formula/code into my excel page. It is working fine. But when I save it, close it, and reopen it, it does not work.

Originally it was asking me to save it as a Macro-enable workbook, which I did. So it is already a Macro-enable booklet.

Any explanations for this?

How can I fix this problem?

Happy to email it to anybody so you can see it.

I simply want the zooming in code put in. so It automatically zooms in for me when i click on certain parts of the page.

Looing forward to hearing you expert opinions on this.

Thankyou,
Scott

 

[littleiitin]

Hi Scott,

I have advised this because I was busy with some other important work at my work area. and it is always a good pratice to start a new thread for new questions...


Thanks
Rahul Kumar Singh

 

[sbrazil]

No problem, thanks Rahul.
But also, I did post it and it seems that i can't get help. So do you know the answer to this question? I posted it again this morning but still no real answers for me.

Thanks Rahul,
Scott

 

[littleiitin]

Hi Scott,

Is your drop down is list box you can set the Width and height of the click event ....

and then on clicking anywhere else you can resize it ....

I need some info...

1) are you using Form Control or Active X control
2) Drop Down is combo box or list box...
3) these drop down in on form or on sheet

send me the detail I will tell you exact code...

Thanks
Rahul Kumar Singh

 

[littleiitin]

Please Ignore previous...

I think u already got the answer....
I misunderstood it...

 

[sbrazil]

Hi Rahul,
Sorry I do not even know what you mean by those questions.

i did not get the answer. One person replied giving me two codes, but I don't know how to enter them. Do I need to have two seperate windows, or enter the two codes in the one window?

Do you understand?

Can I email it to you so you can see what I mean?

Thanks,
Scott