Workbook Protection so it won't open
 

Hi All......
A User wants to password protect a workbook so the workbook will not open
without the password. I only use XL97, 2k, and XP and there appears to be
no means therein to do the job. Oh of course I can hide sheets, and stuff
like that, but no basic feature I can see to do the job untill XL2003.
Anybody know a way to do it in the older versions?

Vaya con Dios,
Chuck, CABGx3

Workbook Protection so it won't open
 

Chuck

Passwording to open a workbook has been available for all past versions I worked
with back to Excel 5.0

FileSave AsToolsOptions or General Options


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 18:03:50 -0400, "CLR" wrote:

Hi All......
A User wants to password protect a workbook so the workbook will not open
without the password. I only use XL97, 2k, and XP and there appears to be
no means therein to do the job. Oh of course I can hide sheets, and stuff
like that, but no basic feature I can see to do the job untill XL2003.
Anybody know a way to do it in the older versions?

Vaya con Dios,
Chuck, CABGx3

Workbook Protection so it won't open
 

Hmmmm, there it was, behind Door #2 <g

Thanking you most kindly Great Sir.............works like a champ.

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Chuck

Passwording to open a workbook has been available for all past versions I
worked
with back to Excel 5.0

FileSave AsToolsOptions or General Options


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 18:03:50 -0400, "CLR" wrote:

Hi All......
A User wants to password protect a workbook so the workbook will not open
without the password. I only use XL97, 2k, and XP and there appears to
be
no means therein to do the job. Oh of course I can hide sheets, and
stuff
like that, but no basic feature I can see to do the job untill XL2003.
Anybody know a way to do it in the older versions?

Vaya con Dios,
Chuck, CABGx3

Workbook Protection so it won't open
 

Most welcome, to be sure.

Gord

On Tue, 8 Jul 2008 18:48:29 -0400, "CLR" wrote:

Hmmmm, there it was, behind Door #2 <g

Thanking you most kindly Great Sir.............works like a champ.

Vaya con Dios,
Chuck, CABGx3



"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Chuck

Passwording to open a workbook has been available for all past versions I
worked
with back to Excel 5.0

FileSave AsToolsOptions or General Options


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 18:03:50 -0400, "CLR" wrote:

Hi All......
A User wants to password protect a workbook so the workbook will not open
without the password. I only use XL97, 2k, and XP and there appears to
be
no means therein to do the job. Oh of course I can hide sheets, and
stuff
like that, but no basic feature I can see to do the job untill XL2003.
Anybody know a way to do it in the older versions?

Vaya con Dios,
Chuck, CABGx3