change macro wih macro, is it possible?
 

Any idea to solve my problem?
I have about 50 + users using the same spreadsheet.
The spreadsheet has a command button with a simple macro running behind

it. When the button is hit it will open I.E and go to the particular
intranet site (specifiy by the IP address).
Recently, the IP adress has been changed. My question is whether
possible for me to create another macro in new spreadsheet (contain the

latest IP address) and email it to all users, and when they open this
new spreadsheet the macro will run automatically (1 time only) to
change the old IP address.
Otherwise, I have to tell everybody how open the code and change the IP

manually which is not efficient because most of them are not familiar
with excel.


Thank you

change macro wih macro, is it possible?
 

Hi Broogle,

See chip Pearson's page 'Programming To The Visual Basic Editor' at:

http://www.cpearson.com/excel/vbe.htm


---
Regards,
Norman



"broogle" wrote in message
oups.com...
Any idea to solve my problem?
I have about 50 + users using the same spreadsheet.
The spreadsheet has a command button with a simple macro running behind

it. When the button is hit it will open I.E and go to the particular
intranet site (specifiy by the IP address).
Recently, the IP adress has been changed. My question is whether
possible for me to create another macro in new spreadsheet (contain the

latest IP address) and email it to all users, and when they open this
new spreadsheet the macro will run automatically (1 time only) to
change the old IP address.
Otherwise, I have to tell everybody how open the code and change the IP

manually which is not efficient because most of them are not familiar
with excel.


Thank you