Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default avoid access of hidden sheets


How can I write a simple code to not allowing others access of hidde
sheets or somewhere in excel to lock them? Thanks in advance.

Joh

--
jt4
-----------------------------------------------------------------------
jt46's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26903

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,327
Default avoid access of hidden sheets

Hi John

There are different ways to make access a little awkward. But bottomline is:
Keep confidential information out of the file. If it's in there then it can
be accessed, and assume that it will be.

HTH. Best wishes Harald

"jt46" skrev i melding
...

How can I write a simple code to not allowing others access of hidden
sheets or somewhere in excel to lock them? Thanks in advance.

John


--
jt46
------------------------------------------------------------------------
jt46's Profile:

http://www.excelforum.com/member.php...o&userid=15154
View this thread: http://www.excelforum.com/showthread...hreadid=269034



Reply
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
How do I avoid copying data from hidden rows/columns? Fred Excel Discussion (Misc queries) 2 February 22nd 08 08:43 PM
using sum function,can I avoid calculating hidden rows UB Excel Worksheet Functions 7 January 4th 07 07:15 PM
How do I avoid referencing hidden values in formulas like OFFSET? K Excel Worksheet Functions 2 July 14th 06 08:46 PM
Access to hidden cells jomo Excel Worksheet Functions 1 January 28th 06 03:42 AM
Avoid user to access first two rows in a sheet Jürgen Excel Programming 5 July 14th 04 10:22 AM


All times are GMT +1. The time now is 01:06 PM.

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"