Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input password or open the sheet as "Read only
Hi,
I've created an Excel sheet that ,when opened,asks the user to input his password or to open the sheet as "Read only",this is fine... I need to add in the Close event of this sheet a VB code to cancel this event,so while the sheet is closed,it can be updated through an Access database that outputs some of its tables in this sheet,but again when any user tries to open it,it asks him to type the passord or to open the sheet as "Read only", Does it make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Excel Discussion (Misc queries) | |||
"Cannot access read-only document" (I get this error when I try to open an Excel file) | Setting up and Configuration of Excel | |||
"Password to Open" Secure? | Excel Discussion (Misc queries) | |||
Excel 2002/2003 can not open xls file says "may be read only" | Excel Discussion (Misc queries) | |||
Password box to remain open after wrong input | Excel Discussion (Misc queries) |