Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Locking Excel worksheets from view?

  1. 31st July 2007, 08:12 PM #11
    incisor's Avatar
    incisor
    incisor is offline SysAdmin (Owner) Vendor
    Join Date
    Apr 2002
    Location
    Godwin Beach 4511
    Posts
    20,694
    Total Downloaded
    32.38 MB
    Quote Originally Posted by jik22 View Post
    Even with good passwords, modern tools will unlock most Office apps in seconds.....
    yep.. do it all the time...

    milliseconds on a quad mac :P

    and usually under 2 minutes on an imate jamin
    2007 Discovery 3 SE7 TDV6 2.7
    2012 SZ Territory TX 2.7 TDCi

    "Make the lie big, make it simple, keep saying it, and eventually they will believe it." -- a warning from Adolf Hitler
    "If you don't have a sense of humour, you probably don't have any sense at all!" -- a wise observation by someone else
    'If everyone colludes in believing that war is the norm, nobody will recognize the imperative of peace." -- Anne Deveson
    “What you leave behind is not what is engraved in stone monuments, but what is woven into the lives of others.” - Pericles
    "We can ignore reality, but we cannot ignore the consequences of ignoring reality.” – Ayn Rand
    "The happiness of your life depends upon the quality of your thoughts." Marcus Aurelius
    Reply With Quote Reply With Quote
  2. 1st August 2007, 12:38 AM #12
    LoveMyV8County's Avatar
    LoveMyV8County
    LoveMyV8County is offline Master Supporter
    Join Date
    Oct 2006
    Location
    The Vines WA
    Posts
    399
    Total Downloaded
    0
    Go to Tools -> Macro - Visual Basic Editor

    About half way down on the lhs there should be a Properties window that shows various attributes of the current worksheet. The last one of these is "Visible", that can be changed to "Hidden" or "VeryHidden".

    Not entirely secure but much more difficult for a casual user to discover than the usual Format -> Sheet -> Hide.

    Chris

    PS My understanding from past research is that passwords for recent Office docs such as Excel can only be broken using brute force so using cryptic (non-dictionary) passwords mixing upper/lower case, numbers and symbols will delay cracking for some time. Just my 2c
    Reply With Quote Reply With Quote
  3. 1st August 2007, 06:10 AM #13
    incisor's Avatar
    incisor
    incisor is offline SysAdmin (Owner) Vendor
    Join Date
    Apr 2002
    Location
    Godwin Beach 4511
    Posts
    20,694
    Total Downloaded
    32.38 MB
    Quote Originally Posted by LoveMyV8County View Post
    PS My understanding from past research is that passwords for recent Office docs such as Excel can only be broken using brute force so using cryptic (non-dictionary) passwords mixing upper/lower case, numbers and symbols will delay cracking for some time. Just my 2c
    i suggest you have a wee look around a few of the lEEt sites, your perception will alter fairly quickly...
    2007 Discovery 3 SE7 TDV6 2.7
    2012 SZ Territory TX 2.7 TDCi

    "Make the lie big, make it simple, keep saying it, and eventually they will believe it." -- a warning from Adolf Hitler
    "If you don't have a sense of humour, you probably don't have any sense at all!" -- a wise observation by someone else
    'If everyone colludes in believing that war is the norm, nobody will recognize the imperative of peace." -- Anne Deveson
    “What you leave behind is not what is engraved in stone monuments, but what is woven into the lives of others.” - Pericles
    "We can ignore reality, but we cannot ignore the consequences of ignoring reality.” – Ayn Rand
    "The happiness of your life depends upon the quality of your thoughts." Marcus Aurelius
    Reply With Quote Reply With Quote
  4. 1st August 2007, 04:05 PM #14
    MickG's Avatar
    MickG
    MickG is offline ChatterBox Silver Subscriber
    Join Date
    Jan 1970
    Location
    Gold Coast, Qld
    Posts
    2,737
    Total Downloaded
    0
    Quote Originally Posted by incisor View Post
    nothing in excel is secure in any way shape or form..

    there are freely available tools that cost nothing that will get you into anything in office...
    Where might one find these tools and go about breaking password protected files?
    '99 Manual TD5 D2.......heap of money spent on it and it has ended
    Reply With Quote Reply With Quote
  5. 1st August 2007, 04:28 PM #15
    incisor's Avatar
    incisor
    incisor is offline SysAdmin (Owner) Vendor
    Join Date
    Apr 2002
    Location
    Godwin Beach 4511
    Posts
    20,694
    Total Downloaded
    32.38 MB
    dogpile is your friend...

    a few searches and you will have all the info you need..

    eg the search string "office password removal" gets you a bucket load of useful info to sift thru...

    ALWAYS virus scan anything you download before using it, some of these things are scams.. :P
    2007 Discovery 3 SE7 TDV6 2.7
    2012 SZ Territory TX 2.7 TDCi

    "Make the lie big, make it simple, keep saying it, and eventually they will believe it." -- a warning from Adolf Hitler
    "If you don't have a sense of humour, you probably don't have any sense at all!" -- a wise observation by someone else
    'If everyone colludes in believing that war is the norm, nobody will recognize the imperative of peace." -- Anne Deveson
    “What you leave behind is not what is engraved in stone monuments, but what is woven into the lives of others.” - Pericles
    "We can ignore reality, but we cannot ignore the consequences of ignoring reality.” – Ayn Rand
    "The happiness of your life depends upon the quality of your thoughts." Marcus Aurelius
    Reply With Quote Reply With Quote
  6. 1st August 2007, 04:37 PM #16
    MickG's Avatar
    MickG
    MickG is offline ChatterBox Silver Subscriber
    Join Date
    Jan 1970
    Location
    Gold Coast, Qld
    Posts
    2,737
    Total Downloaded
    0
    Quote Originally Posted by incisor View Post
    dogpile is your friend...

    a few searches and you will have all the info you need..

    eg the search string "office password removal" gets you a bucket load of useful info to sift thru...

    ALWAYS virus scan anything you download before using it, some of these things are scams.. :P
    You are a clever man Inc Very much appreciated and i tell you, it's faster using this resource than it is talking to the IT guy I sometimes use

    Thanks again and great work, Mick
    '99 Manual TD5 D2.......heap of money spent on it and it has ended
    Reply With Quote Reply With Quote
  7. 1st August 2007, 04:54 PM #17
    jik22's Avatar
    jik22
    jik22 is offline Wizard Subscriber
    Join Date
    Jan 2007
    Location
    Perth, WA
    Posts
    1,655
    Total Downloaded
    0
    Quote Originally Posted by MickG View Post
    Very much appreciated and i tell you, it's faster using this resource than it is talking to the IT guy I sometimes use
    Then you need a new IT guy - especially if he thinks Office passwords are secure!!

    BTW, if anyone else is wondering, the same goes for all your Windows, mobile device and Linux passwords too - if you have physical access to the machine, you can get in as quickly as it takes to reboot. Only high grade encryption of the actual disk contents is worth anything security-wise.
    Jeff

    1994 300TDi Defender
    2010 TDV8 RRS
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
« Microsoft Office XP and AVG | Adsl/adsl2 »

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Search AULRO.com ONLY!
 Search All the Web!