LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default copy text and logo from protected, hidden sheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
showing hidden rows on a protected sheet cathy Excel Discussion (Misc queries) 10 June 6th 08 10:13 PM
password protected logo big b Excel Discussion (Misc queries) 2 September 12th 06 05:11 AM
Strange problems with setting hidden property of a range when sheet protected with UserInterfaceOnly [email protected] Excel Programming 2 June 6th 06 04:15 PM
Protected document loses all protection(hidden columns) when manually copy-pasted [email protected] Excel Discussion (Misc queries) 1 April 4th 06 10:06 PM
protected document loses all protection(hidden columns) when manually copy-pasted [email protected] Excel Worksheet Functions 3 April 4th 06 04:02 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"