Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: disable a macro if current file is not specified file?
Started 1 month, 2 weeks ago by mfarah
Hello, I have an autosave macro that runs at a specified time but only if the file is open. What i have found is that when others make a copy of the file the marco still runs as there is no check on the name or location of the file before the macro is activated. how do i check the file and the path and then disable (not run it) the macro if the name or the path it is is not as I have ...
Site: MrExcel Message Board  MrExcel Message Board - site profile
Forum: Excel Questions  Excel Questions - forum profile
Total authors: 2 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: mrexcel.com

Other posts in this thread:

Andrew Poulsom replied 1 month, 2 weeks ago
ActiveWorkbook.FullName will return the path and name.
Size: 54 bytes
Customize:  Customize "<b>Reply 1</b>: disable a macro if current file is not specified file? :: Excel Questions :: MrExcel Message Board"

mfarah replied 1 month, 2 weeks ago
Quote: Originally Posted by Andrew Poulsom ActiveWorkbook.FullName will return the path and name. not sure I'll ever getthe hang of this - I've got this but there is a compile error Quote: Sub Workbook_Open() Dim thisWorkbook As String thisWorkbook = Workbooks("09_10 Integrated IS...
Size: 1,467 bytes
Customize:  Customize "<b>Reply 2</b>: disable a macro if current file is not specified file? :: Excel Questions :: MrExcel Message Board"

Andrew Poulsom replied 1 month, 2 weeks ago
That code compiles for me. But ActiveWorkbook.FullName includes the path. Why are you just comparing it with the equivalent of ActiveWorkbook.Name? Incidentally, I think you should be using ThisWorkbook (or Me) rather than ActiveWorkbook.
Size: 254 bytes
Customize:  Customize "<b>Reply 3</b>: disable a macro if current file is not specified file? :: Excel Questions :: MrExcel Message Board"

mfarah replied 1 month, 2 weeks ago
thanks for your advice - I'm ovbviously on the right track - will keep plugging along
Size: 85 bytes
Customize:  Customize "<b>Reply 4</b>: disable a macro if current file is not specified file? :: Excel Questions :: MrExcel Message Board"

 

Top contributing authors

Name
Posts
mfarah
6
user's latest post:
disable a macro if current file...
Published (2009-11-10 16:33:00)
thanks for your advice - I'm ovbviously on the right track - will keep plugging along
Andrew Poulsom
4
user's latest post:
disable a macro if current file...
Published (2009-11-10 16:30:00)
That code compiles for me. But ActiveWorkbook.FullName includes the path. Why are you just comparing it with the equivalent of ActiveWorkbook.Name? Incidentally, I think you should be using ThisWorkbook (or Me) rather than ActiveWorkbook.

Related threads on "MrExcel Message Board":

Disable macros after specified date  MrExcel Message Board - site profile Excel Questions - forum profile Disable macros after specified date
Disable macros after specified date
Disable macro using a macro  MrExcel Message Board - site profile Excel Questions - forum profile Disable macro using a macro
Disable macro using a macro
Open another workbook with macro, disable macro in workbook2  MrExcel Message Board - site profile Excel Questions - forum profile Open another workbook with macro, disable macro in workbook2
Open another workbook with macro, disable macro in workbook2
Macro - Enter Specified Value in Selected Cells  MrExcel Message Board - site profile Excel Questions - forum profile Macro - Enter Specified Value in Selected Cells
Macro - Enter Specified Value in Selected Cells
Macro ClearContents specified range cells on multiple...  MrExcel Message Board - site profile Excel Questions - forum profile Macro ClearContents specified range cells on multiple worksheets in a workbook
Macro ClearContents specified range cells on multiple worksheets in a workbook
Enable/disable Macro Message  MrExcel Message Board - site profile Excel Questions - forum profile Enable/disable Macro Message
Enable/disable Macro Message
Enable/Disable Macro Box  MrExcel Message Board - site profile Excel Questions - forum profile Enable/Disable Macro Box
Enable/Disable Macro Box
Disable macro icon  MrExcel Message Board - site profile Excel Questions - forum profile Disable macro icon
Disable macro icon
Disable Macro Icon in the menu bar  MrExcel Message Board - site profile Excel Questions - forum profile Disable Macro Icon in the menu bar
Disable Macro Icon in the menu bar
Is there a way to disable macro after saving copy ?  MrExcel Message Board - site profile Excel Questions - forum profile Is there a way to disable macro after saving copy ?
Is there a way to disable macro after saving copy ?

Related threads on other sites:

Excel asking to disable macro and file contains a type of...  Discussions in microsoft.public.mac.office.excel - site profile microsoft.public.mac.office.excel - forum profile Excel asking to disable macro and file contains a type of macro version 4.0 in microsoft.public.mac.office.excel
Excel asking to disable macro and file contains a type of macro version 4.0 in microsoft.public.mac.office.excel
Disable Macro With Another Macro.  AllExperts Questions/Answers - site profile Excel - forum profile Disable Macro With Another Macro.
Disable Macro With Another Macro.
How Disable Macro-vision On A Pioneer Dv-600  Softpedia Discussion Board - site profile DivXpert Firmwares - forum profile How Disable Macro-vision On A Pioneer Dv-600
How Disable Macro-vision On A Pioneer Dv-600
Disable PHP in specified folder? - PHP  www.daniweb.com - IT Tech Talk - site profile PHP - forum profile Disable PHP in specified folder? - PHP
Disable PHP in specified folder? - PHP
If you buy a camera from Microsoft don't forget to...  Twitter / AlteredEgg - site profile AlteredEgg - forum profile If you buy a camera from Microsoft don't forget to disable macro lenses. 08:52 AM December 10, 2007 from web
If you buy a camera from Microsoft don't forget to disable macro lenses. 08:52 AM December 10, 2007 from web
Disable tooltips for specified elements  Adobe - Forums - site profile Flex - forum profile Disable tooltips for specified elements
Disable tooltips for specified elements
On opening workbook, how to disable macro ?  p2p.wrox.com Forums - site profile Beginning VB 6 - forum profile On opening workbook, how to disable macro ?
On opening workbook, how to disable macro ?
Disable Airport for Specified User  Macworld Forums - site profile Networking and Internet - forum profile Disable Airport for Specified User
Disable Airport for Specified User
Unable to disable macro in microsoft.public.excel  Discussions in microsoft.public.excel - site profile microsoft.public.excel - forum profile Unable to disable macro in microsoft.public.excel
Unable to disable macro in microsoft.public.excel
Disable macro settings in microsoft.public.access.macros  Discussions in microsoft.public.access.macros - site profile microsoft.public.access.macros - forum profile Disable macro settings in microsoft.public.access.macros
Disable macro settings in microsoft.public.access.macros
Thread profile page for "disable a macro if current file is not specified file?" on http://www.mrexcel.com. This report page is a snippet summary view from a single thread "disable a macro if current file is not specified file?", located on the Message Board at http://www.mrexcel.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity