Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Password for Command Button
Name: umich1967 Date: November 7, 2006 at 10:26:06 Pacific OS: Windows XP V.2002 SP2 CPU/Ram: P4 2.8/504 MB Product: Dell
Comment:
I have a workbook containing some data (not sensitive) on several sheets - one for each unit in our department. The first sheet on the workbook has command buttons that will take you to a selected sheet. Can I add a password to each command button so only certain people will be able to view selected sheets?
Name: rhawk7938 Date: November 7, 2006 at 11:01:08 Pacific
Reply:
If I were going to do it, I'd use VBA to bring up an input box when the clicked the button, asking for a password. Then branch to a sub procedure matching that password, where it would execute the appropiate code to open the selected sheets. Hope this helps.
Summary: Hi All I have a weird one for you. I have posdted this on other forums with no answers so trying in here as you have never let me down yet, lol We have a spreadsheet with a command button on that lin...
Summary: Hi there, I use Word 2003 to create a form. The form has two format text boxes, and two command button (which are reset the form and print the form). What I want is develop a macro to hide both comman...
Summary: I created an Excel (2003) worksheet on which I have placed numerous macro buttons. One button puts the date in column "a" on sheet 2. Another puts the time in column "b" on sheet 2. The other button...
0 
