• ## Excel - User Interface Customization

### Security In Microsoft Office

by Published on 2011-05-05 05:13 AM     Number of Views: 31969

Please Note: This text is the complete reproduction of Chapter 17 - Security if Microsoft Office from my book RibbonX: Customizing the Office 2007 Ribbon, and is reproduced with permission of Wiley Publishing who retains the copyright of this work.

This chapter was obviously written for Excel 2007, and still holds true for Office 2010.

In addition, this chapter also discusses macro security applicable to Office 97 through Office 2003. Key portions to read for these versions are Security Prior to Office 2007 and Digital Certificates. While some of the screens may look a little different, they should be close enough to help you understand how to set up a SelfCert digital certificate and add it to your projects. These steps will allow you to avoid macro warnings in your programming environment, without having to sacrifice security by setting your security levels to low. ...

### RibbonX - Customizing the Office 2007 Ribbon (Wiley Publishing)

by Published on 2008-01-16 06:11 AM     Number of Views: 27354

I'm very pleased to be able to share a Chapter from my new book, RibbonX - Customizing the Office 2007 Ribbon.This chapter discusses the comboBox and dropDown RibbonX elements in detail. From using Microsoft's built in elements to creating your own with XML and programming the callbacks with VBA, it displays how to work with them. As you'll see, we provide practical examples for working with the elements in Excel, Word and Access so that you can follow along. ...
• ### Recent Forum Posts

#### Number of consecutive cells in a row

Optional response to your true meaning : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))- COUNTIF(B1:F1,0)...

Roger Haney Yesterday, 08:55 PM

#### Number of consecutive cells in a row

If I understand you correctly, then this formula will work : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))-1. The " -1 " at the end of the...

Roger Haney Yesterday, 08:30 PM

#### Tracking numbers in a row & counting them in columns

Try this one in I5 copied across and down:

=SUMPRODUCT(COUNTIF(\$H5:\$K5,S\$5:S\$13))

=MAX(range) simply finds the...

AliGW Yesterday, 05:32 PM

#### Tracking numbers in a row & counting them in columns

Ali what you did was perfect and brilliant and I have a use for those numbers in that order.

How would the formula be different if my numbers...

ExcelHelpNeeded Yesterday, 04:51 PM

#### Tracking numbers in a row & counting them in columns

That is brilliant! I was making this soooo much more complicated. I have never used or even seen the &MIN and &MAX though. Can you explain how...

ExcelHelpNeeded Yesterday, 03:34 PM