MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Autorun Macro Machine dependant


Posted by Neil B on January 07, 2002 3:46 PM

Hi,
I've seen some amazing stuff on these pages lately.
So I thought someone must know how to Autorun a macro when it is opened on
a specific machine.
I thought the macro could check for a unique signature from the PC in use.
If the signature matched then the macro would kick in.

Any ideas?

Neil B


Posted by Qroozn on January 07, 2002 3:50 PM

re:

do0es this mean the excel program is being run from a shared source or is it on each individuals harddrive?

Posted by Neil B on January 09, 2002 4:23 PM

Re: re:

The excel program will run on individual hard drives
The workbook will be emailed to the main office and opened by
the accounts dept, the macro will unlock the sheet and unhide
various columns.

Thanks