| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting a worksheet
How can I protect worksheets in a workbook where only certain users can view
certain worksheets. So if Joe opens up the workbook he can only see the work sheet for Joe and no others. thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting a worksheet
You could have an input box routine in the Auto_Open Macro. The user would
be asked to imput their name or password. The If - Then Clauses would then be set to make the appropriate sheet visible. The Auto_Open routine would first make only a Title sheet or blank sheet visible. -- Pops Jackson "sherobot" wrote: How can I protect worksheets in a workbook where only certain users can view certain worksheets. So if Joe opens up the workbook he can only see the work sheet for Joe and no others. thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting a worksheet
Oh that sounds good. Do you know what code I could use to write a macro that
would open up a dialog box? I'm kinda new to this. Thanks Pop "Pops Jackson" wrote: You could have an input box routine in the Auto_Open Macro. The user would be asked to imput their name or password. The If - Then Clauses would then be set to make the appropriate sheet visible. The Auto_Open routine would first make only a Title sheet or blank sheet visible. -- Pops Jackson "sherobot" wrote: How can I protect worksheets in a workbook where only certain users can view certain worksheets. So if Joe opens up the workbook he can only see the work sheet for Joe and no others. thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting a worksheet
Then you must be prepared to handle the situation if users disable macros when
they open the workbook. Isn't this fun<g Gord Dibben MS Excel MVP On Fri, 8 Jun 2007 12:05:01 -0700, sherobot wrote: Oh that sounds good. Do you know what code I could use to write a macro that would open up a dialog box? I'm kinda new to this. Thanks Pop "Pops Jackson" wrote: You could have an input box routine in the Auto_Open Macro. The user would be asked to imput their name or password. The If - Then Clauses would then be set to make the appropriate sheet visible. The Auto_Open routine would first make only a Title sheet or blank sheet visible. -- Pops Jackson "sherobot" wrote: How can I protect worksheets in a workbook where only certain users can view certain worksheets. So if Joe opens up the workbook he can only see the work sheet for Joe and no others. thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting a worksheet
So if they disable the macro the code won't work?
"Gord Dibben" wrote: Then you must be prepared to handle the situation if users disable macros when they open the workbook. Isn't this fun<g Gord Dibben MS Excel MVP On Fri, 8 Jun 2007 12:05:01 -0700, sherobot wrote: Oh that sounds good. Do you know what code I could use to write a macro that would open up a dialog box? I'm kinda new to this. Thanks Pop "Pops Jackson" wrote: You could have an input box routine in the Auto_Open Macro. The user would be asked to imput their name or password. The If - Then Clauses would then be set to make the appropriate sheet visible. The Auto_Open routine would first make only a Title sheet or blank sheet visible. -- Pops Jackson "sherobot" wrote: How can I protect worksheets in a workbook where only certain users can view certain worksheets. So if Joe opens up the workbook he can only see the work sheet for Joe and no others. thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting a worksheet
That would be correct.
See this thread for some hints and code to work through for getting an inputbox for a password and how to set up if users disable macros. http://snipr.com/1n8pf Gord On Fri, 8 Jun 2007 15:00:00 -0700, sherobot wrote: So if they disable the macro the code won't work? "Gord Dibben" wrote: Then you must be prepared to handle the situation if users disable macros when they open the workbook. Isn't this fun<g Gord Dibben MS Excel MVP On Fri, 8 Jun 2007 12:05:01 -0700, sherobot wrote: Oh that sounds good. Do you know what code I could use to write a macro that would open up a dialog box? I'm kinda new to this. Thanks Pop "Pops Jackson" wrote: You could have an input box routine in the Auto_Open Macro. The user would be asked to imput their name or password. The If - Then Clauses would then be set to make the appropriate sheet visible. The Auto_Open routine would first make only a Title sheet or blank sheet visible. -- Pops Jackson "sherobot" wrote: How can I protect worksheets in a workbook where only certain users can view certain worksheets. So if Joe opens up the workbook he can only see the work sheet for Joe and no others. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting worksheet | Excel Discussion (Misc queries) | |||
| Protecting worksheet | Excel Worksheet Functions | |||
| Protecting Worksheet | Excel Discussion (Misc queries) | |||
| Protecting worksheet | Excel Programming | |||
Linear Mode
