Disabling Macros After A Save To A Different Filename
 

I have a routine that poles a client for a filename then saves th
document in the client's designated folder. Is there a way to disabl
or strip the macros/userforms from being run when viewing thi
alternately created folder through that save macro? Possibly poling th
file name before run? I would like them to be able to view this newl
created file without being run through the entry form. Any help i
greatly appreciated. I don't have the luxury of making it an add-in, i
must stay self contained in the origional form. Any help is greatl
appreciated.
Thanks in Advanc

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Disabling Macros After A Save To A Different Filename
 

Hi R3df1sh,

This page on Chip Pearson's site should get you started:

http://www.cpearson.com/excel/vbe.htm

If you can't use an addin with templates, you're probably stuck with this
method.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


R3df1sh wrote:
I have a routine that poles a client for a filename then saves the
document in the client's designated folder. Is there a way to disable
or strip the macros/userforms from being run when viewing this
alternately created folder through that save macro? Possibly poling
the file name before run? I would like them to be able to view this
newly created file without being run through the entry form. Any help
is greatly appreciated. I don't have the luxury of making it an
add-in, it must stay self contained in the origional form. Any help
is greatly appreciated.
Thanks in Advance


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

Disabling Macros After A Save To A Different Filename
 

You could have a boolean value in a cell, on a hidden sheet perhaps.
All your top level procedures (e.g. Workbook_Open) could check this
value; if it's True the procedure executes normally. Your 'routine
that poles a client' could set this value to False, effectively
disabling the macros.

R3df1sh wrote in message ...
I have a routine that poles a client for a filename then saves the
document in the client's designated folder. Is there a way to disable
or strip the macros/userforms from being run when viewing this
alternately created folder through that save macro? Possibly poling the
file name before run? I would like them to be able to view this newly
created file without being run through the entry form. Any help is
greatly appreciated. I don't have the luxury of making it an add-in, it
must stay self contained in the origional form. Any help is greatly
appreciated.
Thanks in Advance


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/