Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to bypass password when pasting FROM a protected workbook
I can use code to open a password-protected workbook, and copy data
from a worksheet. However, when I try to paste the data into a unprotected workbook (and unprotected worksheet), Excel prompts for a password. I am very sure this happens at the PASTE stage, because I traced the issue line by line using the STOP command to see where the application prompts for the password. Question is, I have already opened thw workbook by supplyhing the pwd in the VBA code. Why does Excel prompts for password before I paste to a UNPROTECTED worksheet? How do I avoid this in vba code? Thanks in advance for your kind help. Larry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to bypass password when pasting FROM a protected workbook
Unprotecting a workbook does not unprotect the sheets in the workbook.
Each sheet must be individually unprotected. -- Jim Cone Portland, Oregon USA http://www.mediafire.com/PrimitiveSoftware (Lottery Numbers.xls... Excel picks numbers for 14 state/national (USA) lotteries - free) "Larry" wrote in message ... I can use code to open a password-protected workbook, and copy data from a worksheet. However, when I try to paste the data into a unprotected workbook (and unprotected worksheet), Excel prompts for a password. I am very sure this happens at the PASTE stage, because I traced the issue line by line using the STOP command to see where the application prompts for the password. Question is, I have already opened thw workbook by supplyhing the pwd in the VBA code. Why does Excel prompts for password before I paste to a UNPROTECTED worksheet? How do I avoid this in vba code? Thanks in advance for your kind help. Larry |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to bypass password when pasting FROM a protected workbook
Larry presented the following explanation :
I can use code to open a password-protected workbook, and copy data from a worksheet. However, when I try to paste the data into a unprotected workbook (and unprotected worksheet), Excel prompts for a password. I am very sure this happens at the PASTE stage, because I traced the issue line by line using the STOP command to see where the application prompts for the password. Question is, I have already opened thw workbook by supplyhing the pwd in the VBA code. Why does Excel prompts for password before I paste to a UNPROTECTED worksheet? How do I avoid this in vba code? Thanks in advance for your kind help. Larry The 'Open' password only allows you to open the file. It has nothing to do with protection. As Jim states, workbook protection is separate from worksheet protection. You must re-apply protection (specifying the 'UserInterfaceOnly:=True' parameter) after a workbook is opened if you want code to work on protected sheets. The UserInterfaceOnly parameter does not persist after the workbook is closed, making it a 'runtime only' option we have to reset every time. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to bypass password when pasting FROM a protected workbook
Thanks, Jim and Gary,
I'll check whether the worksheet is protected as well. Cheers, Larry On Jan 16, 3:29*am, GS wrote: Larry presented the following explanation : I can use code to open a password-protected workbook, and copy data from a worksheet. However, when I try to paste the data into a unprotected workbook (and unprotected worksheet), Excel prompts for a password. I am very sure this happens at the PASTE stage, because I traced the issue line by line using the STOP command to see where the application prompts for the password. Question is, I have already opened thw workbook by supplyhing the pwd in the VBA code. Why does Excel prompts for password before I paste to a UNPROTECTED worksheet? How do I avoid this in vba code? Thanks in advance for your kind help. Larry The 'Open' password only allows you to open the file. It has nothing to do with protection. As Jim states, workbook protection is separate from worksheet protection. You must re-apply protection (specifying the 'UserInterfaceOnly:=True' parameter) after a workbook is opened if you want code to work on protected sheets. The UserInterfaceOnly parameter does not persist after the workbook is closed, making it a 'runtime only' option we have to reset every time. -- Garry Free usenet access athttp://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link two cell from two workbook bypass password | Excel Discussion (Misc queries) | |||
How To Get Into a Password Protected Workbook | Excel Programming | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |