Categories
Excel

Preventing Users from Printing a Workbook

Learn how to grant people access to your workbook while removing their ability to print its content. Also, how to use VBA to disable printing for the entire workbook or a particular worksheet.

Categories
Excel

Prevent Saving a Workbook

You can specify that any workbook be saved as read-only by checking the “Read-only recommended” checkbox to prevent a user from saving any changes he might make to the file.
You also can prevent users from being able to save a copy of your workbook to another directory or folder with or without a different name.

Categories
Excel

Using VBA to Group and Ungroup Worksheets

Although manually grouping and ungrouping sheets is easy, you must remember to group and ungroup your sheets as needed or else you will inadvertently overtype data from another worksheet. You can overcome these shortcomings by using some very simple VBA code.

Categories
Excel

Group and Ungroup Worksheets

It’s fairly ordinary to have the same data appear in multiple worksheets simultaneously. You can use Excel’s tool for grouping so that data in one workbook can be entered into multiple worksheets at the same time.

Categories
Excel

Arrange Workbook Windows

Learn how to arrange workbooks so they don’t overlap each other and you’re able to view or edit their data without having to switch from one workbook to another.

Categories
PHP

Trigonometry, Exponential and Logarithmic Functions

PHP supports the set of trigonometry functions, the PHP’s mathematical library also includes the exponential and logarithmic functions.

Categories
PHP

Reordering array elements with array_reverse( )

Often it’s useful to consider an array in reverse order. The array_reverse( ) function creates a new array by reversing the elements from a source array.

Categories
PHP

Using Generators and Yield

PHP generators are a powerful feature that allow you to create iterators without writing a class that implements the Iterator interface.

Categories
PHP

Using SFTP

FTP is not a secure protocol and should not be used. PHP also offers SSH-based functions that helps you to create a secure FTP (SFTP) connection to your web server.

Categories
PHP

Connecting with FTP Server

PHP comes with built-in support for FTP and a special set of functions that implement the complete FTP functionality defined in the associated Request for Comment (RFC).