This article shows how to use PDFCreator to make a PDF that leverages some of their security features. Specifically, we'll create a file that uses: A "File open" password 128 bit encryption Preventing content copying Preventing modification Preventing printing These
Restores default yellow colour for all comment on the worksheet. Can easily be modified to change all comments to a different colour by changing the value of the lDefaultCommentColor variable. Where to place the code: This code goes in a
This code replaces all external links with their values, changes the colour of the background cell (so that you can see where), and places the original link path in a comment. If a comment already existed, it appends the original
There are three types of spreadsheets built in the world today: The "quick 'n' dirty for your eyes only" type spreadsheet. It doesn't need to be pretty, and doesn't need a ton of time spent making it readable or understandable
Many users mistakenly place their VBA code in the wrong area, which can lead to their code not working, errors and large amounts of frustration. This page contains a listing of the different types of objects which can hold code,
This article shows how to retrieve a recordset from a database and place it in an Excel worksheet, using an ADO connection to pass SQL strings. Examples of where this function shines: Works well for retrieving data from Access (or
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
