HOW TO CREATE MACRO...

[Guest]

Hi

I using files that shares in network. My question

1) How to create macro or setting - when user open that files automaticaly fix to zoom that I set

2) How to create macro - when user open that files automaticaly updates links

3) How to create macro - when user open that files automaticaly enable macros

Thanks.

 

[Frank Kabel]

Hi
1. Use the workbook_open event (in your workbook module). Something
like
sub workbook_open()
ActiveWindow.Zoom = 75
end sub
Also see: http://www.cpearson.com/excel/events.htm

2. You can set this in the Options tab

3. Not possible as this is a security feature. You may set the security
level to 'Low' but I wouldn't recommend this

 

[Guest]

Hi, Mr.Frank Kabe
Thanks for your guide

Regarding no.2 & 3. That files share in network by all users. Do you mean each user have do that
Pls help me to solve this problem..
Thank

----- Frank Kabel wrote: ----

H
1. Use the workbook_open event (in your workbook module). Somethin
lik
sub workbook_open(
ActiveWindow.Zoom = 7
end su
Also see: http://www.cpearson.com/excel/events.ht

2. You can set this in the Options ta

3. Not possible as this is a security feature. You may set the securit
level to 'Low' but I wouldn't recommend thi


-
Regard
Frank Kabe
Frankfurt, German


Param wrote

 

[Frank Kabel]

Hi
see your other post