Re: $$Excel-Macros$$ Preventing unauthorized access for your excel files

2010-07-22 Thread Rajesh Srinivasaraghavan
e 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.co

RE: $$Excel-Macros$$ Preventing unauthorized access for your excel files

2010-07-22 Thread Dave Bonallack
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 acces

$$Excel-Macros$$ Preventing unauthorized access for your excel files

2010-07-22 Thread Rajesh Srinivasaraghavan
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