View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cjorgensen cjorgensen is offline
external usenet poster
 
Posts: 1
Default xlSheetVeryHidden issue

Hello,
I am currently creating an application where I have the following
issue:

My file includes several sheets that should not be accessible for the
user. Some of the sheets though contains data that my code needs to
access - and since it is not possible to copy a range (or is there a
way??) without unhiding the sheet temporarily, the program will be
vournable if the users breaks the processing of the code (by
Ctrl+Break).

Is there
a) some way to access data from the sheets (we are talking thousands of
rows) without using copy function?
b) Is there some way to prevent the user from breaking excecution using
Ctrl+Break?

Hope someone can help me out there!!

Greetings from Norway,
Christian


---
Message posted from http://www.ExcelForum.com/