| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read only without password
Hi
I am trying to create a read only open access copy of a file that is password protected. Trouble is I can't remove the password from the copy only and force read only onto the copy This is the code I tried Private Sub CommandButton1_Click( Application.DisplayAlerts = Fals Kill "S:\Common\Gx\x.XLS ActiveWorkbook.SaveAs ("s:\unit\q.xls"), FileFormat:=xlNormal, Password:="", WriteResPassword:=" ", ReadOnlyRecommended:=True , CreateBackup:=Fals ActiveWorkbook.SaveCopyAs ("S:\Common\Gx\x.XLS" Application.DisplayAlerts = Tru ActiveWorkbook.Clos End Su Appreciate any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input password or open the sheet as "Read only | Excel Discussion (Misc queries) | |||
| Password Prompt With Read Only Option | Excel Discussion (Misc queries) | |||
| Password opens as read only? | Excel Discussion (Misc queries) | |||
| Read only password script box | Excel Discussion (Misc queries) | |||
| How do I make a file read only unless a password is supplied? | Excel Discussion (Misc queries) | |||
Threaded Mode
