View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
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