Comments for The Ken Puls (Excelguru) Blog http://www.excelguru.ca/blog More geeky stuff from the author of www.excelguru.ca... Mon, 08 Apr 2013 18:54:54 +0000 hourly 1 http://wordpress.org/?v=3.5.1 Comment on Trigger Conditional Formats Before Printing by Jeff Weir http://www.excelguru.ca/blog/2009/05/11/trigger-conditional-formats-before-printing/comment-page-1/#comment-178381 Jeff Weir Mon, 08 Apr 2013 18:54:54 +0000 http://www.excelguru.ca/blog/2009/05/11/trigger-conditional-formats-before-printing/#comment-178381 Instead of toggling, won’t this work:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
[rngPrintMode] = “True”
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
[rngPrintMode] = “False”
Cancel = True
End Sub

]]> Comment on Giving PowerPivot a Keyboard Shortcut by Ken Puls http://www.excelguru.ca/blog/2013/04/03/giving-powerpivot-a-keyboard-shortcut/comment-page-1/#comment-178378 Ken Puls Mon, 08 Apr 2013 16:05:50 +0000 http://www.excelguru.ca/blog/?p=594#comment-178378 It should be doing exactly that… what is it opening for you?

Try going to the PowerPivot tab and pressing ALT, then G. What is the shortcut for the Manage window?

]]> Comment on Giving PowerPivot a Keyboard Shortcut by Timer http://www.excelguru.ca/blog/2013/04/03/giving-powerpivot-a-keyboard-shortcut/comment-page-1/#comment-178366 Timer Sat, 06 Apr 2013 06:14:15 +0000 http://www.excelguru.ca/blog/?p=594#comment-178366 Is is possible to open also the powerpivot window?

]]> Comment on Giving PowerPivot a Keyboard Shortcut by Ken Puls http://www.excelguru.ca/blog/2013/04/03/giving-powerpivot-a-keyboard-shortcut/comment-page-1/#comment-178360 Ken Puls Thu, 04 Apr 2013 15:22:25 +0000 http://www.excelguru.ca/blog/?p=594#comment-178360 Seriously? Doh! I’ll have to check, but maybe the GY# is dependant on other add-ins and such. Fortunately 2013 has an official set of letters now.

]]> Comment on Giving PowerPivot a Keyboard Shortcut by Kevin Springer http://www.excelguru.ca/blog/2013/04/03/giving-powerpivot-a-keyboard-shortcut/comment-page-1/#comment-178359 Kevin Springer Thu, 04 Apr 2013 15:05:49 +0000 http://www.excelguru.ca/blog/?p=594#comment-178359 Great job! SendKeys is something I don’t use all that much but I can see new uses for it.

The only problem I had was for it to work, I needed to replace “%GY2? with “%GY6?.

]]> Comment on MVP Summit 2008 – Sunday by Ken Puls http://www.excelguru.ca/blog/2008/04/20/mvp-summit-2008-sunday/comment-page-1/#comment-178334 Ken Puls Sat, 23 Mar 2013 01:53:54 +0000 http://www.excelguru.ca/blog/2008/04/20/mvp-summit-2008-sunday/#comment-178334 The person taking the picture was holding up the server from delivering the next round. ;)

]]> Comment on MVP Summit 2008 – Sunday by Christopheer http://www.excelguru.ca/blog/2008/04/20/mvp-summit-2008-sunday/comment-page-1/#comment-178329 Christopheer Thu, 21 Mar 2013 21:24:44 +0000 http://www.excelguru.ca/blog/2008/04/20/mvp-summit-2008-sunday/#comment-178329 Cool picture.But only 4 people smiled?

Christopher

]]> Comment on One hell of a weekend! by Ross http://www.excelguru.ca/blog/2013/03/12/one-hell-of-a-weekend/comment-page-1/#comment-178301 Ross Sat, 16 Mar 2013 09:09:59 +0000 http://www.excelguru.ca/blog/?p=574#comment-178301 Well done Ken, sounds like a fun weekend too!

Where do you go from here :-)

]]> Comment on I’m a guest author now too… by http://hugegenicreview.com http://www.excelguru.ca/blog/2013/02/07/im-a-guest-author-now-too/comment-page-1/#comment-178296 http://hugegenicreview.com Thu, 14 Mar 2013 04:26:33 +0000 http://www.excelguru.ca/blog/?p=562#comment-178296 Hola! I’ve been reading your weblog for a while now and finally got the bravery to go ahead and give you a shout out from Huffman Texas! Just wanted to tell you keep up the great work!

]]> Comment on One hell of a weekend! by Curt Frye http://www.excelguru.ca/blog/2013/03/12/one-hell-of-a-weekend/comment-page-1/#comment-178295 Curt Frye Wed, 13 Mar 2013 06:59:52 +0000 http://www.excelguru.ca/blog/?p=574#comment-178295 What a terrific weekend. Way to go all around!

]]>