I would like to have a sheet and in column A I would like it to show the users names, Column B Passwords, Column C and on to be the sheets. Using this sheet I would like to create a user name and password for a workbook and have it prompt me for the user and password but through the sheets above I would also like the user to have a visiblity to see other only the sheets that i allow them to see. The first sheet would be hidden to everyone else but me the Admin and just was wondering if there was a way to lock the enables macros so the user has no choise but to type in a user and a password.
Thanks for the Help everyone.
9  1269 
I would like to have a sheet and in column A I would like it to show the users names, Column B Passwords, Column C and on to be the sheets. Using this sheet I would like to create a user name and password for a workbook and have it prompt me for the user and password but through the sheets above I would also like the user to have a visiblity to see other only the sheets that i allow them to see. The first sheet would be hidden to everyone else but me the Admin and just was wondering if there was a way to lock the enables macros so the user has no choise but to type in a user and a password.
Thanks for the Help everyone.
Hello, golf32902!
Are you hoping to have log in information stored in a spreadsheet and run VB code to prompt users for the information included, grant access to specific sheets? http://www.oreilly.com/catalog/exceladn/toc.html
You'll need to do some digging, but this is quite fetching:-)
Please let us know if not helpful...
Hello, golf32902!
Are you hoping to have log in information stored in a spreadsheet and run VB code to prompt users for the information included, grant access to specific sheets?
http://www.oreilly.com/catalog/exceladn/toc.html
You'll need to do some digging, but this is quite fetching:-)
Please let us know if not helpful...
Yes this is exactly what i would like to do. I just dont know how to create it. I just started to learn VB6 through VB for Dummies.
Yes this is exactly what i would like to do. I just dont know how to create it. I just started to learn VB6 through VB for Dummies.
Good, go through the link I gave you, what you need is there, looks pretty basic..
Good, go through the link I gave you, what you need is there, looks pretty basic..
will whit still work for version 2000?
will whit still work for version 2000?
I imagine it should, it's only year younger than VB 6. Please let us know if up to snuff...
I imagine it should, it's only year younger than VB 6. Please let us know if up to snuff...
I got this from ozgrid. I was wondering if you could show me how to make it have visiblity for sheets and if possible for cell visiblity too through the username and password sheet. thanks
[HTML]http://www.ozgrid.com/FreeDownloads/PasswordBook.zip[/HTML]
I got this from ozgrid. I was wondering if you could show me how to make it have visiblity for sheets and if possible for cell visiblity too through the username and password sheet. thanks
http://www.ozgrid.com/FreeDownloads/PasswordBook.zip
Greetings, golf32902!
I am not sure understand:
(1) You must unzip the file
(2) You'll need to use the default Username and Password
Are you saying this info is not visible to you?
Greetings, golf32902!
I am not sure understand:
(1) You must unzip the file
(2) You'll need to use the default Username and Password
Are you saying this info is not visible to you?
It is visible I just wonted to show you the link to one that works for me. Thanks for your help.
It is visible I just wonted to show you the link to one that works for me. Thanks for your help.
Sorry for the misunderstanding, it is indeed very useful, and you're quite welcome:-)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: MissiMaths |
last post by:
I have used outputTo to export a copy of a table out of access into
excel. I was wondering if there is anyway to set a password on this
within the code so that it is read only in .xls format?
I...
|
by: Vivek |
last post by:
Hi all,
I am trying to import data from an excel sheet to MSSQL server 2000
using a web application (C#).
Since I have to validate the data in the excel sheet, the approach i
have used is to get...
|
by: |
last post by:
I am writing a small program that needs to be able to open Excel
workbooks which are password protected. Does anyone know how to do this,
without any interaction from the user? I am sure it is...
|
by: Mamatha |
last post by:
Hi
When i clicked a button, i want to insert data from
listview in VB.NET to Excel sheet.
If you know the solution either above or below is ok for
me.
I know how to insert from a textfile,but...
|
by: |
last post by:
I wrote a class in VB.NET to export the contents of a datagrid to Excel. It
works perfectly on my machine, but it fails on my customers' PCs that have
identical versions of Win XP (SP1) and Excel...
|
by: Frank M. Walter |
last post by:
Hello,
I have made an small AddIn with udf for excel 2003.
I use vs2003.
The point of view is the function __T()
I call it in excel sheet writing =__T()
I am not able to set a value to a...
|
by: nusratfatima |
last post by:
Hi ,
In my Perl Application, a mail is send to the administrator.
This mail contains an attachment which is a csv sheet.
Now, i need to add a Password to the same.
The coding that i follow...
|
by: grego9 |
last post by:
Is it possible to create a macro that prompts the user to enter a password to access a specific sheet in Excel 2000?
I can protect a sheet - but I cannot get a password prompt if the user tries to...
|
by: hemantbasva |
last post by:
Note We need to have a template on server for generating report in multiple sheet
as we do not had msoffice on server
moreover this require a batch job to delete excel file created by the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
