Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
Macro to change Macro code? | Excel Programming |