Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Len
Make sure the macros knows it's you that runs them, if not then exit before doing stuff. Either check the logon username with some API, and then something like If StrUser < "LenB" then Exit sub or check if one of your own computer's files is present If Dir("C:\Hunks\Arnie.mov") = "" then exit sub or something like that, use your imagination. Pretty useful and simple, but requires protected code so no one can read your criteria. -- HTH. Best wishes Harald Followup to newsgroup only please. "LenB" wrote in message ... Thanks for the replies. Is there anyway to disable the macros? My spreadsheet has icons on them that have macros assigned to them. I would like to inactivate the macros (or icons) when I send the worksheet to another third party. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i disable macros? | Excel Discussion (Misc queries) | |||
Enable/Disable macros | Excel Discussion (Misc queries) | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Enable/Disable Macros | Excel Programming | |||
en-/disable macros pop-up | Excel Programming |