Dear Umesh, VBA project + Excel Worksheet is protected to enforce the user authentication. You also need to make sure that before distribution it to user(s), password is incorporated. password is sairam. Once you open the project, you can replicate it for several users... enjoy...:)
Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 11/29/09, matkarumesh <matkarum...@gmail.com> wrote: > > thanx > dilip..but i want to know the codes ...could you pls provide me attachment > without VBA passward ..so i can able to read codes > > Umesh matkar > > > On Sun, Nov 29, 2009 at 12:11 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Dear Umesh, >> >> Workbook open password has to be one, and after that workbook opens as a >> common for users. Microsoft has not provided a feature to enter seperate >> passwods for different users, though in worksheets you can designate some >> range/rows/columns to specific users. >> >> Alternatively, I have automated it so that after opening of a workbook, a >> user has to click on his name and offcourse has to enter his unique >> password, to get access to his designated worksheets. >> Open the attached file and check out the functioning. >> Mr. Raju -> password is raju >> Mr. Shankay -> password is shankar >> >> Note:- you cannot open worksheets using commands like >> Format->Sheet->unhide >> Get back me in case of any queries. >> >> Best Regards, >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 11/28/09, Umesh Matkar <matkarum...@gmail.com> wrote: >> >>> Dear Excel Guru’s, >>> >>> Please help me >>> >>> >>> >>> I want to create macro for workbook which using for showing different >>> persons different sales report..but I want to use different passward for >>> different person >>> >>> For e.g (for mr raju – passward may be “Raju” , Mr Sankay – Passward may >>> be “Sanjay” etc.) >>> >>> >>> >>> If we put passward raju…excel shows only sheet 1 and sheet 2 >>> >>> When put passward sanjay…excel shows only sheet3 and sheet4 >>> >>> Like this >>> >>> >>> >>> Thanx >>> >>> Umesh matkar >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 2. Excel tutorials at http://www.excel-macros.blogspot.com >>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com >>> 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com or >>> Ashish Jain @ 26may.1...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,500 subscribers worldwide and receive many nice notes >>> about the learning and support from the group. Our goal is to have 10,000 >>> subscribers by the end of 2009. Let friends and co-workers know they can >>> subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> >> > > > -- > Warm Regards, > > You mesh > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
