Announcement

Collapse
No announcement yet.

VBA Macros

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Iconiq
    replied
    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

    Leave a comment:


  • gazing_south
    replied
    Re: VBA Macros

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

    Leave a comment:


  • A_M
    replied
    Re: VBA Macros

    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.

    Leave a comment:


  • Thundergod
    replied
    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

    Leave a comment:


  • Iconiq
    started a topic VBA Macros

    VBA Macros

    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
Working...
X