Hi,
Is there any VBA code that closes the Workbook if a user does not agree to
enable macros on startup?.
TIA,
Mickey
Hi,
Is there any VBA code that closes the Workbook if a user does not agree to
enable macros on startup?.
TIA,
Mickey
Hi what i suggest you do is create a workbook with an auto_open sub in it which calls the workbook you want them to be able to work on this way if the first workbook has Macros Disabled by the user then it will not call your workbook!
HTH
Simon
MDlake, if the user does not enable macros how is the code to close the
workbook going to run? Have a look here for a workaround
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
"MBlake" <mickeyblake@btinternet.com> wrote in message
news:OinmZEjVFHA.3280@TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any VBA code that closes the Workbook if a user does not agree to
> enable macros on startup?.
>
> TIA,
> Mickey
>
Maybe you could lock and protect the entire workbook and have the startup
macro unlock it. That way if the user does not enable the macros the
workbook will be useless.
"MBlake" wrote:
> Hi,
> Is there any VBA code that closes the Workbook if a user does not agree to
> enable macros on startup?.
>
> TIA,
> Mickey
>
>
>
Thanks for the replies, I looked at the code suggested and also a resource
here which I found very useful, others may as well -
http://www.vbaexpress.com/kb/getarti...b_id=379#instr
Thanks again,
Mickey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks