+ Reply to Thread
Results 1 to 47 of 47

Canned Replies

  1. #1
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Canned Replies

    I just noticed the 'Canned Replies' dropdown today, nice touch.

    Could I ask that a snippet on how to enter array formulas be added? It could save a lot of typing.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    Hmmmm... I don't see that dropdown anywhere How do you access it?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    When I hit 'Reply To Thread', it is up above the icon bar, just below the Quick Reply' bar.

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    That's funny, you must be one of the select few who see that, or I am one of the select few who do not see that.

  5. #5
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    How odd. Tell me how I can embed a pic, and I will post an image.

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    I usually just do a print screen a save as a .jpg and upload as attachment.... I don't have much luck with the <img> method. we went through that here: http://www.excelforum.com/the-water-...u-do-that.html

    here's how I see it attached... maybe you are a moderator in disguise
    Attached Images Attached Images
    Last edited by NBVC; 08-22-2012 at 02:32 PM.

  7. #7
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    Well as you can see I get that dropdown

    Canned Replies.png

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    Very interesting... maybe it is a browser thing... I am currently on Firefox 10.0.1

    I just check on an older version of I.E. and don't see it there either...

  9. #9
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    I am using Chrome.

  10. #10
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    ... another EF mystery.....

  11. #11
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    I also have Firefox 12 on another machine, I see it there too. And on IE 8.0. Most odd.

    Anyway, we digress. Can anyone add a snippet for me?

  12. #12
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Canned Replies

    I see it in IE8
    Entia non sunt multiplicanda sine necessitate

  13. #13
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Canned Replies

    I get access to it with Firefox and IE9

    It's supposed to be accessible to all "Forum Vetrans?", "Gurus","Mods" & "Admin" according to Arlette.

  14. #14
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    ... i guess I am not loved....

  15. #15
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Canned Replies

    I just got on with IE8 after using Chrome and I cannot see any Canned Replies.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  16. #16
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    So you don't see them in either of the 2 browsers?

  17. #17
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Canned Replies

    No I do not.

  18. #18
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    Well, that can only mean one thing.... :evil: ... the blacklist rears its ugly head.....

  19. #19
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Canned Replies

    I think you are right!

  20. #20
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Canned Replies

    None for me.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  21. #21
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Canned Replies

    NBVC,

    We had extended the invitation to you to join the Forum Veterans but you declined, hence you are not able to see the canned replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  22. #22
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Canned Replies

    To answer your question Bob.
    Goto to your User CP and check the list of links on the left.

    MySettings.jpg
    Cheers
    Andy
    www.andypope.info

  23. #23
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    As I had not set the existing items I had assumed it was a board set of values. I can see the value of having a global set and personal extensions, but I still think array entering would help many of us so could/should be global. But thanks, I can update it now.

  24. #24
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Canned Replies

    So now if anyone who is a veteran decides to change the canned replies they can. Nice touch, I remember them being screwed up before & having to redo them all when I was admin & that was when Canned Replies were restricted & the owners suddenly allowed any mod to change them.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  25. #25
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Canned Replies

    The veterans cannot edit the existing rules.

  26. #26
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    According to Marcol....

    Quote Originally Posted by Marcol View Post
    It's supposed to be accessible to all "Forum Vetrans?", "Gurus","Mods" & "Admin" according to Arlette.
    Last time I looked I was in the "Gurus" list.... anyway doesn't matter.

  27. #27
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Canned Replies

    Marcol has it 75% right - its the forum veterans, admins & mods who have access to the canned replies.

  28. #28
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    That's fine! Whatever!

  29. #29
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Canned Replies

    Hmm?

    So a "Forum Guru" is not necessarily a "Forum Vetran", and a "Forum Vetran" need not be a "Forum Guru".
    Who decides?
    Surely NBVC qualifies under anyones' stretch of the imagination?

    It's a bit Monty Python-ish to have him excluded just because he's Canadian! ...
    Last edited by Marcol; 08-23-2012 at 08:39 AM.

  30. #30
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Canned Replies

    It's more that he is an ex-mod. I can't see them either & Simon & myself added them

  31. #31
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    Thanks Marcol... don't worry about it. They get their highs on these nuances, hoping it pisses people off...

  32. #32
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Canned Replies

    As i said before, NBVC was invited but he didnt want to be part of the Veterans. Hence, he is not seeing the canned messages.

  33. #33
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Canned Replies

    Oooh, do you get a flat cap and pewter tankard for being a forum veteran?

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  34. #34
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Canned Replies

    yep,got mine in the post last week, i'm sitting here with cap on and supping a beer from the tankard.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  35. #35
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Canned Replies

    Quote Originally Posted by martindwilson View Post
    yep,got mine in the post last week, i'm sitting here with cap on and supping a beer from the tankard.
    Martin , considering I am sloshed right now, I am ordering you to post in the The official (unofficial) beer thread.

  36. #36
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Canned Replies

    Hmmm, that is very strange. I don't recall being "invited" to join the veteran's forum, yet I'm a Forum Guru and an ex-Mod.

    Arlette, would you please explain why I was overlooked? Or, have you added me to the "Blacklist" as well?
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  37. #37
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Canned Replies

    CX,

    As i have stated before, i am not adding anyone to the blacklist. It happens at the server level.

    Our list of Veterans is not a closed list. Any members wanting to be part of it can surely ask to be added. Do you want to be part of this group?

  38. #38
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Canned Replies

    Me, me, me!!!

    Dom

  39. #39
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Canned Replies

    Jesus, what have I started? Raising all of these tired old battles all over again. I saw a good feature, and all I wanted was to save some typing.

  40. #40
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Canned Replies

    Your Canned Replies question opened a Can of worms

  41. #41
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Canned Replies

    I'd like to know what exactly a forum veteran is? To me, a veteran is someone with a minimum time served so what are those requirements?

  42. #42
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Canned Replies

    Awsome, my IP was blocked . probably b/c I posted in the "I am not posting here any more" thread. So I have to turn to a VPN to post here. Thanks very much.

  43. #43
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Canned Replies

    Quote Originally Posted by arlu1201 View Post
    As i have stated before, i am not adding anyone to the blacklist. It happens at the server level.
    These things don't "just happen" because the server wants to do it.

  44. #44
    Forum Contributor day92's Avatar
    Join Date
    04-20-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 360
    Posts
    600

    Re: Canned Replies

    Quote Originally Posted by Mordred View Post
    These things don't "just happen" because the server wants to do it.
    HAHAHAHA

  45. #45
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Canned Replies

    Quote Originally Posted by arlu1201 View Post
    CX,

    As i have stated before, i am not adding anyone to the blacklist. It happens at the server level.

    Our list of Veterans is not a closed list. Any members wanting to be part of it can surely ask to be added. Do you want to be part of this group?
    Arlette,

    Adding users to the Blacklist happens at the server level??? Wow, that must be some interesting piece of code. Please ask the "Tech Team" to post that code! I'm sure many here would love to see it.

    My point regarding the Veterans forum concerns how it is being administrated. Defining the forum as "a forum for those who have reached Guru or Mod or otherwise Senior status" is one thing; but that isn't what it is. If it was, then everyone would have automatic access the moment they reached Guru status (whether they wanted to take advantage of that access or not). It has been limited to invitation only by a chosen few, and by that prejudicial nature, is alienating many in this community. Now you are saying it's okay for me to ask permission to be invited? Okay, I will say yes; but not just for myself, I ask that all Gurus, Mods, Ex-Mods, & Seniors be given access. Stop the "invitation only" crap, it's insulting.

  46. #46
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Canned Replies

    @ arlu1201

    Yes, I'd like to be added. I have my "own" canned replies that I keep in a NotePad Folder...it saves typing but is cumbersome to access on the fly. Canned Replies would be nice to have access to.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  47. #47
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Canned Replies

    Attempting to keep this thread on topic, the discussion relating to banning has been moved to a separate thread.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1