QUOTE(tope10 @ 18 Aug, 2008 - 10:23 PM)
QUOTE(ALVINCHAAND @ 17 Aug, 2008 - 12:46 PM)
I HAVE 2 WORKBOOKS. ONE WITH VARIOUS NAMES, COUNTRY, GENDER AND THE OTHER WITH INFO ON THE PEOPLE WITH THOSE NAMES(ADDRESS, TEL NUM ETC)
I ALSO HAVE TWO TYPES OF USERS. ADMIN AND NORMAL USERS.
ADMIN IS ALLOWED TO UPDATE DATA IN THE ABOVE MENTIONED WORKBOOKS WHILE THE NORMAL USER CAN ONLY VIEW THE DATA AFTER DOING A SEARCH
WHAT CAN I DO SO THAT THE ADMIN IS ABLE TO UPDATE THE SAME PAGE AND WHEN DISPLAYED TO A USER, THE USER CAN ONLY VIEW THE INFO?
Your problem is so called user access level. In order to do that you have to check if the username during login is an admin or a normal user. IF your username is store on the database you are going to add a fields as for a user type. then in your vb code you are going to check it if username is for admin or not.
To set the Excel file for un editable you can use the printpreview. function.
obj_excel.Worksheets.PrintPreview
obj_excel.Worksheets.Visible = True
Hello and thank you so much for your help i am truly grateful...i am just a beginner in VB and this is my first task. i really have no clue on how to go about doing alot of things in there... i will really apreciate if u could guide me along.
the code u provided:
obj_excel.Worksheets.PrintPreview
obj_excel.Worksheets.Visible = True
where am i to add them so that the user can view and the admin can view and edit
| 