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.
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.
Hmmmm... I don't see that dropdown anywhereHow 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.
When I hit 'Reply To Thread', it is up above the icon bar, just below the Quick Reply' bar.
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.
How odd. Tell me how I can embed a pic, and I will post an image.
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![]()
Last edited by NBVC; 08-22-2012 at 02:32 PM.
Well as you can see I get that dropdown
Canned Replies.png
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...
I am using Chrome.
... another EF mystery.....
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?
I see it in IE8
Entia non sunt multiplicanda sine necessitate
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.
... i guess I am not loved....![]()
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---
So you don't see them in either of the 2 browsers?
No I do not.
Well, that can only mean one thing.... :evil: ... the blacklist rears its ugly head.....
I think you are right!
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
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]
To answer your question Bob.
Goto to your User CP and check the list of links on the left.
MySettings.jpg
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.
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
The veterans cannot edit the existing rules.
Marcol has it 75% right - its the forum veterans, admins & mods who have access to the canned replies.
That's fine! Whatever!
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.
It's more that he is an ex-mod. I can't see them either & Simon & myself added them
Thanks Marcol... don't worry about it. They get their highs on these nuances, hoping it pisses people off...
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.
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.
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
Martin , considering I am sloshed right now, I am ordering you to post in the The official (unofficial) beer thread.
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.
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?
Me, me, me!!!
Dom
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.
Your Canned Replies question opened a Can of worms![]()
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?
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.
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.
@ 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.
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 theicon 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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks