ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/120566-re-protected-worksheet.html)

DumbComputerUser

Protected worksheet
 
Use your Microsoft Help and type "Password" in the search bar. I just did
this for the first time today. It's an excellent tutorial.

"GJD" wrote:

Is there a way to permit only certain people to see a worksheet tab within a
workbook?


GJD

Protected worksheet
 
Thanks. That is a good general demo, but it doesn't answer the question I
have. Can you set up a tab that only certain people can see? Or can you
hide a tab and require a password to unhide it?

"DumbComputerUser" wrote:

Use your Microsoft Help and type "Password" in the search bar. I just did
this for the first time today. It's an excellent tutorial.

"GJD" wrote:

Is there a way to permit only certain people to see a worksheet tab within a
workbook?


Gord Dibben

Protected worksheet
 
It can be done but gets a little unwieldy.

Read Dave Peterson's response to a similar question.

http://snipurl.com/13klj


Gord Dibben MS Excel MVP

On Thu, 30 Nov 2006 12:13:01 -0800, GJD wrote:

Thanks. That is a good general demo, but it doesn't answer the question I
have. Can you set up a tab that only certain people can see? Or can you
hide a tab and require a password to unhide it?

"DumbComputerUser" wrote:

Use your Microsoft Help and type "Password" in the search bar. I just did
this for the first time today. It's an excellent tutorial.

"GJD" wrote:

Is there a way to permit only certain people to see a worksheet tab within a
workbook?


Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com