User logging
User logging
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: User logging

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way in which to embed code which is not disabled when macros are have been disabled on opening the sheet?
    Any help would be much appreciated.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HI Andy --

    OK look this is a big pain i agree but needed, there are billions of post on this one, Win XP and Office XP wont allow macros to open if security high,, only medium... thats how seriouse it is Macros Virus is a threat not so big now but was and stil is.. larus 1 and larus II were heavey nasty french buggers that distroyed data ..

    i STRONGLY suggest sufferin gthe OK click obne yoy have checked OK ILL OPEN THAT ONE not just cick OK..

    Thats the point PAINFUL, but needed some nasty guys see it fun to distroy others work and system, personall ill like to walk down a dark alley wit a virus programmer and have a chat about one or two chat about some thing virus related.

    STICK with it..

    OK Fix:

    YES programming can fixx this but even if i do or di know il will not post the answer OK not the rules of this board but exceptance and common sence will defend me, i never hold information unless dangerouse which is fair.

    And also if you buy a signature it digital from MSoft you get around this.. as known source.

    Others if you set to low (NOT RECOMENDED) on LAN NOT EVER EMAIL, then ok warining will be removed,

    Set to low ----- bNEVER RECOMENDED I CAN NOT STRESS THIS POINT ENOUGH....

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Would it make a difference if the only way the user could use the functions in a spread sheet he/she had to use user forms?

    Perhaps I should elaborate on the finer details of my problem...

    I need a system which I could could send to my cutomers, enabling them to modify the layout and content of their website. This is all done by user forms and FTP. I could notify them that they must enable macros to use the spreadsheet sucessfully but I don't want them to be able to see the formuae contained within the sheets. I could protect the spreadsheet, to safeguard the cells but cracking the code to sheet protection is easy peasy and many of my customers would know this. I reckon the safest way in which to protect my code is in VB macros etc. as the view code protection is harder to break into (I think/hope!).

    What I really need to know is is there any way I could either write the code (via a macro) to the spreadsheet, will the macro (although possibly disabled) will be readable by the user? Can I hide anything in Excel (cells or vb)?

    I once had a macro which generated PDF files which I could not read/view (even when I got the right password), any idea how they did it?

    Thanks for your time.

  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What about hidden worksheets?

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tell me more....

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Can i request how do you hide these work sheets

    and how will others open them if hidden...??


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    What I mean't was...put all the formulas on the hidden worksheets and just have links or the values on the visible worksheets. I don't know the application so I don't know if this will work.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com