| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook with password
I have Excel 2007 workbook I don't want any user opening up a particular
workbook unless he insert a password. I try to use the workbook password, but I can see the workbook that I don't want. In no way I want the user to see anything at all. Only a user who has the correct password can see the workbook. How do I do that. Thank you in advance. Cheers |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with password
don't have 2007 right now, but in 2003, choose save as.
then click tools, then the general options button you will see password to open. -- Gary "CAM" wrote in message ... I have Excel 2007 workbook I don't want any user opening up a particular workbook unless he insert a password. I try to use the workbook password, but I can see the workbook that I don't want. In no way I want the user to see anything at all. Only a user who has the correct password can see the workbook. How do I do that. Thank you in advance. Cheers |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with password
works the same in 2007
-- Gary Excel 2003 "Gary Keramidas" <GKeramidasAtMsn.com wrote in message ... don't have 2007 right now, but in 2003, choose save as. then click tools, then the general options button you will see password to open. -- Gary "CAM" wrote in message ... I have Excel 2007 workbook I don't want any user opening up a particular workbook unless he insert a password. I try to use the workbook password, but I can see the workbook that I don't want. In no way I want the user to see anything at all. Only a user who has the correct password can see the workbook. How do I do that. Thank you in advance. Cheers |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with password
Thanks Gary I will give it a try.
Regards, "Gary Keramidas" wrote in message ... works the same in 2007 -- Gary Excel 2003 "Gary Keramidas" <GKeramidasAtMsn.com wrote in message ... don't have 2007 right now, but in 2003, choose save as. then click tools, then the general options button you will see password to open. -- Gary "CAM" wrote in message ... I have Excel 2007 workbook I don't want any user opening up a particular workbook unless he insert a password. I try to use the workbook password, but I can see the workbook that I don't want. In no way I want the user to see anything at all. Only a user who has the correct password can see the workbook. How do I do that. Thank you in advance. Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password to open workbook | Excel Discussion (Misc queries) | |||
| I know my password, yet it will not open my workbook | Excel Worksheet Functions | |||
| Open workbook with password. | Excel Programming | |||
| need to open my workbook not asking for password so i can do so | Excel Discussion (Misc queries) | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Linear Mode
