Excelguru.ca - Powered by vBulletin
  • Register
  • Help

  • Home
  • Products & Services
    • Live Training
    • Video Courses
    • Private Courses
    • Consulting & Mentoring
    • Training Calendar
    • Books
    • Affiliate Sales Program
    • About Us
    • Today's Posts
    • FAQ
    • Calendar
    • Community
      • Member List
    • Forum Actions
      • Mark Forums Read
    • Quick Links
      • View Site Leaders
  • Blog
  • Forum
    • Excelguru Forums
    • What's New?
    • Today's Posts
    • Forum Guide
    • Forum FAQ
    • Supported BB Code Tags
  • Resources
    • Online Training
    • Recommended Books
    • Add-ins & Tools
    • Excel Blogs
    • Useful Links
  • Knowledge Base
  • Contact Us
  • Advanced Search
  • Home
  • Home
  • Knowledge Base Articles

  1. If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.
    Register here so that you can post in the forums or comment on the articles.

  • Knowledge Base Articles By Category

    Access - ADO (4)
    Access - SQL (4)
    Access - VBA Programming (10)
    Downloads - Games (1)
    Downloads - Learning Aids (11)
    Downloads - Utilities (9)
    Excel - ADO (4)
    Excel - Charts and Data Visualization (1)
    Excel - Formulas (8)
    Excel - General Tips (36)
    Excel - Interactive Pages (9)
    Excel - PivotTables (12)
    Excel - Power Query (3)
    Excel - PowerPivot (7)
    Excel - SQL (4)
    Excel - UDF (7)
    Excel - User Interface Customization (2)
    Excel - VBA Programming (49)
    Excel - WebApp (4)
    Internet Explorer - VBA Programming (1)
    Novell Groupwise - VBA Programming (2)
    Other - General (1)
    Outlook - General Tips (5)
    Outlook - VBA Programming (7)
    PDF Creator - VBA Programming (11)
    Power BI (3)
    PowerPoint - VBA Programming (7)
    Publisher - VBA Programming (7)
    Syndicated Articles (7)
    Training Products (10)
    Word - VBA Programming (8)
  • Excel - User Interface Customization

    Security In Microsoft Office 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2011-05-06 06:13 AM     Number of Views: 23918 

    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. ...
    Read More Read More

    RibbonX - Customizing the Office 2007 Ribbon (Wiley Publishing) 

    by
    Ken Puls
    • View Profile
    • View Forum Posts
    • View Blog Entries
    • Visit Homepage
    • View Articles
    Published on 2008-01-16 07:11 AM     Number of Views: 19441 

    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. ...
    Read More Read More
  • MVP Logo
  • Recent Forum Posts

    majid

    how to add additional date and other column PIVOT table?

    Hi all,
    i need your help to understand this how the attached file add to extra column in a pivot table. i received from some one but don't know...

    majid Today, 07:13 AM Go to last post
    alansidman

    Power Query to move 24 values

    Attach a sample workbook
    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need....

    alansidman Today, 03:15 AM Go to last post
    p45cal

    Macro for filtering/copying/and pasting to new tabs

    try:

    Code:
    Public Sub sing_off_formatting()
    'Creates tabs for sing off analysis macroeach of the desired reports
    Set PS = Sheets.Add(After:=Sheets(Sheets.Count))
    ...

    p45cal Today, 12:37 AM Go to last post
    p45cal

    VBA Auto Add Hyperlink based on Cell Values when Data is updated

    On each of the sheets concerned, unlock all the cells on the sheet, then lock the cells in the columns containing the formulae you want to protect....

    p45cal Yesterday, 11:53 PM Go to last post
    mielkew

    VBA Auto Add Hyperlink based on Cell Values when Data is updated

    Thank you so much, that sound perfect if we can protect it. However does the query will still be able to refresh? That's what I did earlier were I tried...

    mielkew Yesterday, 10:52 PM Go to last post
  • Contact Us
  • Excelguru Forums
  • Archive
  • Top
All times are GMT +1. The time now is 08:18 AM.
Powered by vBulletin® Version 4.2.5
Copyright © 2019 vBulletin Solutions Inc. All rights reserved.
Pre-Defined Posts provided by Post Templates v1.6.1pl1 (Free) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Thread / Post Bookmarks provided by Thread / Post Bookmarking v1.2.0 (Free) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
Copyright © 2004 - by Excelguru Consulting Inc.
Gravatar by 1e2.it