Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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




  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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






  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Workbook protection micksa Excel Discussion (Misc queries) 3 April 15th 08 01:40 PM
Removing an open file password protection Dollster Excel Worksheet Functions 0 November 24th 06 03:21 PM
excel 2003 saved file will not open without a blank workbook open Bob Excel Discussion (Misc queries) 4 November 11th 06 04:24 PM
Workbook protection Bonbon Excel Worksheet Functions 8 April 27th 06 01:54 PM
Search open sheets in workbook and insert into open sheet punx77 Excel Discussion (Misc queries) 0 March 6th 06 05:07 PM


All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"