Results 1 to 5 of 5

Thread: VBA Macros

  1. #1
    Senior Member
    Join Date
    Feb 2008
    Posts
    130

    VBA Macros

    Gene Cafe Coffee Roaster $850 - Free Beans Free Freight
    Hey guys,

    I know there are a lot of computery people on the forum so I hoped someone might be able to help me with this,

    Ive written a macro in exel, now Id like to share the spread sheet with my mates at work, but I dont want anyone to be able to see the code Ive used, or adjust it for that matter,

    Does anyone know how to keep the code private whilst keeping the program working. Ive found some options for securing the macro, but then you cant run it either...

    Any help would be greatly appriciated!!!

    Des

  2. #2
    Sleep is overrated Thundergod's Avatar
    Join Date
    Jul 2006
    Location
    Sydney
    Posts
    10,496

    Re: VBA Macros

    Im not saying Im an Excel expert but have managed to tweak a few spreadsheets in my day.

    To make it easier for me would you email me a copy to work on?

    Alternatively theres a great website (Mr Excel) that has lots of answers to lots of Excel questions.

    Try this search result page:
    http://www.google.com/cse?cx=014928669287693717265%3Ar0igph5fyzs&q=prote ct+macro&sa=Search&cof=FORID%3A1

  3. #3
    A_M
    A_M is offline
    Guest
    Join Date
    Mar 2006
    Posts
    6,381

    Re: VBA Macros

    Quote Originally Posted by 1F233E252F2E392C242F4B0 link=1242175342/1#1 date=1242177663
    Im not saying Im an Excel expert but have managed to tweak a few spreadsheets in my day.

    To make it easier for me would you email me a copy to work on?

    Alternatively theres a great website (Mr Excel) that has lots of answers to lots of Excel questions.

    Try this search result page:
    http://www.google.com/cse?cx=014928669287693717265:r0igph5fyzs&q=protect +macro&sa=Search&cof=FORID:1

    I agree with TG as to Mr Excel and again, I have some experience but not extensive...

    With out seeing the sheet it makes it hard as to what your doing and where you putting your work..

    If using Macros, it can be a pain as well as others may have their system set to disable by default... Thus regardless of what protection you place on cells etc.. It will not work.

    In addition, depending on the version of excel your using, that can also add to confusion... Office 2007 does some interesting things and can cause people some grief.

  4. #4
    Member
    Join Date
    Jun 2007
    Posts
    51

    Re: VBA Macros

    This should work
    http://www.ozgrid.com/VBA/protect-vba-code.htm

  5. #5
    Senior Member
    Join Date
    Feb 2008
    Posts
    130

    Re: VBA Macros

    Thanks guys, TG, Ill try get a copy of the sheet to you on Tuesday, could you PM me with an email address?

    Gazing South, I found that option, but when i tried it, it actually disabled the macro completly, maybe i did something else at the same time, Ill go have a play with it, thanks for the advice!

    Des



Similar Threads

  1. I-macros and Firefox users
    By beanflying in forum Off Topic
    Replies: 2
    Last Post: 15th July 2010, 07:55 PM

Posting Permissions

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