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: 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/

 
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
my xlSheetVeryHidden is hidden and I can't unhide it - HELP! cristine Excel Discussion (Misc queries) 4 May 14th 23 11:46 AM
Can't get my xlSheetVeryHidden cristine Excel Worksheet Functions 2 June 26th 09 09:30 PM
Sum issue Tim Hill[_2_] Excel Worksheet Functions 1 October 14th 08 06:20 PM
SUM Issue.. HELP Setting a Mileage Expense Report[_2_] Excel Discussion (Misc queries) 4 November 15th 07 06:49 PM
worksheets xlSheetVeryHidden and show them once password-app Param Excel Worksheet Functions 0 March 27th 06 01:54 AM


All times are GMT +1. The time now is 10:02 AM.

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

About Us

"It's about Microsoft Excel"