Results 1 to 6 of 6

Thread: Can you hide/password VBA code in a workbook ?

  1. Sep 24th, 2001, 08:51 AM #1
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Question Can you hide/password VBA code in a workbook ?

    Is it possible to stop users pressing ALT/F11 and viewing the VBA code attached to a workbook ?

    Any response much appreciated ! Need to keep the buggers out !!!!
    Reply With Quote Reply With Quote
  2. Sep 24th, 2001, 09:38 AM #2
    c@lle
    c@lle is offline
    Addicted Member c@lle's Avatar
    Join Date
    Oct 1999
    Location
    Belgium
    Posts
    179
    you can enter a password in the menu 'extra' , security.
    Reply With Quote Reply With Quote
  3. Sep 24th, 2001, 09:57 AM #3
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818
    Wheres that exactly ?
    Reply With Quote Reply With Quote
  4. Sep 24th, 2001, 10:29 AM #4
    c@lle
    c@lle is offline
    Addicted Member c@lle's Avatar
    Join Date
    Oct 1999
    Location
    Belgium
    Posts
    179
    i haven't excel here in english

    it's in the menu 'extra' then the topic right above the second small line (or the 7th topic) something like 'security' or 'password'

    there you can protect workbooks
    Reply With Quote Reply With Quote
  6. Sep 24th, 2001, 10:44 AM #5
    InvisibleDuncan
    InvisibleDuncan is offline
    Fanatic Member InvisibleDuncan's Avatar
    Join Date
    May 2001
    Location
    Eating jam.
    Posts
    819
    In your project explorer, right-click your project, select VBAProject Properties and choose the Protection tab.
    Indecisiveness is the key to flexibility.

    www.mangojacks.com
    Reply With Quote Reply With Quote
  7. Sep 25th, 2001, 02:53 AM #6
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818
    Thanks ID.

    That did the trick
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width