Posted to microsoft.public.excel.programming

external usenet poster

Posts: 5

Password on Command Button

Hi

I have a very simple Command Button that is used for a user to change
worksheet however I would like to password protect this so that only certain
users can change into this sheet is anyone able to advise how to complete
this?

Current simple code is as follows:

Private Sub CommandButton1_Click()
Sheets("Sheet2").Select
End Sub

Thanks
Robin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
password protect a macro on a command button	dave caizley	Excel Programming	4	September 21st 07 02:49 PM
Password Protecting a command button	newguyA14	Excel Programming	5	April 18th 07 02:10 PM
Password Protecting a command button.	newguyA14	Excel Programming	0	April 18th 07 01:34 PM
how can I assign a password to a command button	Help!	Excel Programming	2	January 4th 06 01:52 PM
Command Button Password	Cindy	Excel Programming	3	January 14th 04 04:32 PM

All times are GMT +1. The time now is 09:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us