Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save activeworkbook with a password
Am looking for a macro which would save my activeworkbook in its
existing location with a password (e.g "1234"). Can anybody help - thxs |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save activeworkbook with a password
Try:-
Sub saveme() ActiveWorkbook.Password = "1234" ActiveWorkbook.Save End Sub Mike " wrote: Am looking for a macro which would save my activeworkbook in its existing location with a password (e.g "1234"). Can anybody help - thxs |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save activeworkbook with a password
On May 17, 12:52 pm, Mike H wrote:
Try:- Sub saveme() ActiveWorkbook.Password = "1234" ActiveWorkbook.Save End Sub Mike " wrote: Am looking for a macro which would save my activeworkbook in its existing location with a password (e.g "1234"). Can anybody help - thxs thxs - works great !! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotecting (with password) the activeworkbook | Excel Programming | |||
Activeworkbook.save | Excel Programming | |||
ActiveWorkbook.Save DOESNT WORK !! | Excel Programming | |||
ActiveWorkbook.Protect password:=range("rangename") does not work | Excel Discussion (Misc queries) | |||
troubles with ActiveWorkbook.Save | Excel Programming |