Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro on Password
Is there a way to have a password protect on a workbook and once end user
keys in the password, the workbook status will changed to modified? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro on Password
the easiest way to do this is to have the workbook always believe it has been
changed as soon as you open it. In the ThisWorkbook module, put the following macro... Private Sub Workbook_Open() Application.ActiveWorkbook.Saved = False End Sub That will make the workbook always believe that it needs to be saved. -- Hope this helps. Thanks in advance for your feedback. Gary Brown "acss" wrote: Is there a way to have a password protect on a workbook and once end user keys in the password, the workbook status will changed to modified? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
Password protect macro via a macro | Excel Programming | |||
Macro & Password | Excel Discussion (Misc queries) | |||
How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
How to see macro code of a password protected macro without a password? | Excel Programming |