Good day everyone,
Is there such code that forces the user to enable the macros in order to
open a file?
In other words, if the user "disable" the macros, then the file cannot be
opened.
Thanks for your time...
Denys
Good day everyone,
Is there such code that forces the user to enable the macros in order to
open a file?
In other words, if the user "disable" the macros, then the file cannot be
opened.
Thanks for your time...
Denys
Denys, have a look here,
http://www.danielklann.com/excel/for...be_enabled.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Denys" <[email protected]> wrote in message
news:[email protected]...
> Good day everyone,
>
> Is there such code that forces the user to enable the macros in order to
> open a file?
>
> In other words, if the user "disable" the macros, then the file cannot be
> opened.
>
> Thanks for your time...
>
> Denys
Just for clarification, the answer is no.
--
Regards,
Tom Ogilvy
"Denys" wrote:
> Good day everyone,
>
> Is there such code that forces the user to enable the macros in order to
> open a file?
>
> In other words, if the user "disable" the macros, then the file cannot be
> opened.
>
> Thanks for your time...
>
> Denys
Denys wrote:
> Good day everyone,
>
> Is there such code that forces the user to enable the macros in order to
> open a file?
>
> In other words, if the user "disable" the macros, then the file cannot be
> opened.
>
> Thanks for your time...
>
> Denys
Hi Denys.
No.
But perhaps you could use the Workbook_BeforeClose event handler to
"cripple" your workbook in some fashion (e.g. Protect all the cells or
make the sheets Very Hidden - apart from the one that says "If you
don't enable the macros, you don't get the worksheets!") and restore it
to health with Workbook_Open.
Regards
Steve
Good morning,
Thanks for your answers. I used to hide my sheets just before closing. But
Scoops, you gave me a good idea... I will make the sheets very hidden instead
of "visible = true". It should help..
Have a good day
Denys
"Scoops" wrote:
>
> Denys wrote:
> > Good day everyone,
> >
> > Is there such code that forces the user to enable the macros in order to
> > open a file?
> >
> > In other words, if the user "disable" the macros, then the file cannot be
> > opened.
> >
> > Thanks for your time...
> >
> > Denys
>
> Hi Denys.
>
> No.
>
> But perhaps you could use the Workbook_BeforeClose event handler to
> "cripple" your workbook in some fashion (e.g. Protect all the cells or
> make the sheets Very Hidden - apart from the one that says "If you
> don't enable the macros, you don't get the worksheets!") and restore it
> to health with Workbook_Open.
>
> Regards
>
> Steve
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks