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

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

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

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

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

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