Hi,Create a new sheet. On that, in large font, enter "Macros must be enabled to
use this workbook."Create a workbook close event macro that makes all sheets
xlveryhidden except the new sheet.Create a workbook open event macro that hides
the new sheet and unhides all the others.If the macros are disabled on open,
the open workbook macro wont run, the notice sheet will be displayed, and all
others will be hidden.(Sheets that are xlveryhidden can only be opened by
vba)Regards - Dave.
Date: Thu, 22 Jul 2010 15:29:46 +0530
Subject: $$Excel-Macros$$ Preventing unauthorized access for your excel files
From: taur...@gmail.com
To: excel-macros@googlegroups.com
Hi Group,
I need help in preventing unauthorized users from accessing my excel work
book(s). Right now i have written the following vba code to achieve my
objective. However, if some one were to choose to click 'Disable Macros', they
can still access the contents of my file.
Sub auto_open()
UserN = Application.UserName
Select Case (UserN)
...
...Show contents if UserN is a authorized user else, close the work book
...
I am looking for means to close the file the moment an unauthorized person
tries to access my file(s). Can some one help?
Regards
Rajesh
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
_________________________________________________________________
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
