Ravi Shankar

Tweaking Apps

prevent

Prevent users from adding new worksheet in Excel

By 2 Comments

Excel 2016, 2013 and 2010 provides an option to prevent users from adding new worksheet to existing Workbook structure. So if you are the owner of Excel file and you do not want to allow other users to add any new worksheet, rename or move worksheet then you can use Protect Workbook Structure option to change the permission. You can access Protect Workbook Structure from the Info menu.

image

Click the File menu and then navigate to Info menu and click the drop down arrow under Protect Workbook option. From the list of available option select Protect Workbook Structure. This would display the following Protect Structure and Windows. Mark the check box with label as Structure. If you want to password protect it then enter a password in the Password field. Click Ok button to save and confirm the changes.

image

Prevent automatic insertion of current date in Word

By 5 Comments

This is in reference to a query posted by one of the blog reader on “how to prevent the date field getting automatically updated with the current date in a Word document. We had already seen the steps required to insert current date or modify date format for the date in Word 2016, 2013 & 2010. Similarly you can stop Word from the changing the date to the system date by following the below simple steps

Step 1: Open the document with the date field.

Step 2: Select the date field then click the Insert menu and navigate to Text section.

image

Step 3: Click the Date & Time option available under Text section.

image

Step 4: In the Date and Time window, un mark the check box with label as Update automatically then click OK button to confirm and save the changes.

By this way Word users can stop automatic update of date field to the current date.

Prevent installing or uninstalling apps on iPad or iPhone

By 1 Comment

Prevent

In this tutorial we will be see the steps required to prevent any users from installing or uninstalling any apps on iPad or iPhone. This is a useful tip if you are sharing your iPad with other people especially kids and do not want them accidentally uninstall and install any Apps.

To prevent users from removing or installing apps, press the menu button on your iPad and tap the Settings icon.

image

In the General Settings, tap the Restriction option and enable restrictions by setting a passcode. In the Restrictions screen, navigate to Installing Apps and Deleting Apps Option.

image

By tapping them and changing the value to Off would prevent users from removing or installing any apps on iPhone or iPad.