Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings:
Required to copy text and logos from what is now a password protected, hidden sheet called "HEADINGS". Paste onto NON hidden sheet called "CoverPage". The follow code shown below worked great during my set-ups and trials, until I hid the sheet. I found out one can't select or actually activate a hidden sheet. When I did use .activate (regarding hidden sheet), I could did the text, but not the logos. Is there a way to accomplish this without un-hiding the sheet? Sub CdnContract() Application.ScreenUpdating = False Application.EnableEvents = False ' I don't know why this is in here Sheets("CoverPage").Select Call WSh_Unprotect Sheets("HEADINGS").Activate Call WSh_Unprotect ' Copy and Paste Canadian Heading and Logos Worksheets("HEADINGS").Range("HEAD_CDN").Copy ActiveSheet.Paste Destination:=Worksheets("Coverpage").Range("B2") Application.EnableEvents = True Application.ScreenUpdating = True Call WSh_Protect Sheets("HEADINGS").Activate Call WSh_Protect Sheets("CoverPage").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
showing hidden rows on a protected sheet | Excel Discussion (Misc queries) | |||
password protected logo | Excel Discussion (Misc queries) | |||
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly | Excel Programming | |||
Protected document loses all protection(hidden columns) when manually copy-pasted | Excel Discussion (Misc queries) | |||
protected document loses all protection(hidden columns) when manually copy-pasted | Excel Worksheet Functions |