Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro code to change file-opening password
i have created a testing tool which is meant for administering a test containing multiple-choice questions. the test-taker is given a copy of the file, and a password (say, "open_sesame", without the quotes) which allows him to start the test. after he has completed the test, he needs to click a button which runs a macro that saves and closes the file. I also want this macro to change the password (from "sesame" to the contents of cell A1 in Sheet1) before it is saved and closed. the idea is to make the file unusable a second time, becasue the test-taker would not know password to start the test once it has been re-set. can you help me with the macro code for re-setting the password. thanks. -- arunjoshi ------------------------------------------------------------------------ arunjoshi's Profile: http://www.excelforum.com/member.php...fo&userid=8846 View this thread: http://www.excelforum.com/showthread...hreadid=379593 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro code to change file-opening password
Good morning Arunjoshi This code should help: Sub Save1() Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:="C:\Book4.xls", Password:="password1" Application.DisplayAlerts = True Application.Quit End Sub When called this macro will save the file Book4.xls to the location C:\ with the password set as password1, irrespective of whether or not another password was set to the file. The Application.Quit command will then close Excel. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=379593 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file opening password | Excel Discussion (Misc queries) | |||
Is there any way to be prompted for a password when opening a file | Excel Discussion (Misc queries) | |||
How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
Code to select 'Disable Macro' when opening an EXTERNAL FILE | Excel Programming |