Communication methods
Results 1 to 5 of 5

Thread: Communication methods

  1. #1
    Board Regular TinaP's Avatar
    Join Date
    Jan 2005
    Location
    Ohio
    Posts
    521
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Communication methods

    Greetings Excellers!

    I'm currently working on a workbook with lots of UDFs and other volatile functions. Trust me, I've done my research and the UDF/volatile function mode is the preferred method in this instance. (The key phrase is "in this instance.") I also have other workbooks where macros/recalculations take extended periods. Recalcs take exponentially longer if more than one workbook is open. And occasionally I turn off automatic calculation which I know can cause all kinds of headaches that I should warn users about.

    My question to all of you is: How do you communicate this information to users? I have tried inserting a "Read Me" sheet in workbooks but it never gets read. If the workbook already has macros I've inserted messages when the workbook is opened. How do you handle this?
    I not only use all the brains that I have, but all that I can borrow. --Woodrow Wilson

  2. #2
    Board Regular BlakeSkate's Avatar
    Join Date
    Jan 2015
    Posts
    431
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Communication methods

    I create a "front page" for my user workbooks. It includes stats for the data, instructions, known bugs, as well as noted comments so they click the correct things. Generally format it in a way that is appealing to look at and organized. That way the user is more inclined not to skip the important stuff.
    -------------------------------------------------------------------------------
    I may not give the best VBA codes, but they sure are VBA codes.
    Help me help you by posting a snapshot of your data & your expected result
    Please use [ code][ /code] tags when posting VBA as well as proper indentation

  3. #3
    Board Regular BlakeSkate's Avatar
    Join Date
    Jan 2015
    Posts
    431
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Communication methods

    if you wanted to be a stickler you could create a password that someone can only know if they read your readme
    -------------------------------------------------------------------------------
    I may not give the best VBA codes, but they sure are VBA codes.
    Help me help you by posting a snapshot of your data & your expected result
    Please use [ code][ /code] tags when posting VBA as well as proper indentation

  4. #4
    Board Regular TinaP's Avatar
    Join Date
    Jan 2005
    Location
    Ohio
    Posts
    521
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Communication methods

    Quote Originally Posted by BlakeSkate View Post
    if you wanted to be a stickler you could create a password that someone can only know if they read your readme
    You have a little evil streak, don't you? I think we will get along just fine.
    I not only use all the brains that I have, but all that I can borrow. --Woodrow Wilson

  5. #5
    Board Regular BlakeSkate's Avatar
    Join Date
    Jan 2015
    Posts
    431
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Communication methods

    Quote Originally Posted by TinaP View Post
    You have a little evil streak, don't you? I think we will get along just fine.
    I ABSOLUTELY am evil. its a necessity to be evil to your end users. Otherwise they break everything.
    -------------------------------------------------------------------------------
    I may not give the best VBA codes, but they sure are VBA codes.
    Help me help you by posting a snapshot of your data & your expected result
    Please use [ code][ /code] tags when posting VBA as well as proper indentation

Some videos you may like

User Tag List

Tags for this Thread

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
  •