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.
Author: BrainBell
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.
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.
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.
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.
PHP supports the set of trigonometry functions, the PHP’s mathematical library also includes the exponential and logarithmic functions.
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.
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.
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.
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).