Thanks Dave. I will try this! Regards Rajesh
On Thu, Jul 22, 2010 at 6:37 PM, Dave Bonallack <davebonall...@hotmail.com>wrote: > 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 > > ------------------------------ > Find it on Domain.com.au <http://domain.com.au/> Need a new place to > live?<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 > -- ---------------------------------------------------------------------------------- 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
