LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default How to disable macros?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i disable macros? whatzzup Excel Discussion (Misc queries) 1 March 14th 06 01:51 PM
Enable/Disable macros Adam Excel Discussion (Misc queries) 2 March 11th 05 10:29 AM
Suppress the Disable Macros / Enable Macros Dialog Shoji Karai Excel Programming 5 September 24th 03 03:10 AM
Enable/Disable Macros Joseph[_6_] Excel Programming 3 August 23rd 03 02:54 PM
en-/disable macros pop-up James[_10_] Excel Programming 1 July 22nd 03 05:55 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"