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
