• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • About
  • Portfolio
  • Privacy Policy

prevent

Prevent users from adding new worksheet in Excel

January 25, 2016 By Ravi Shankar 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

Filed Under: Excel, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: add sheet, Excel 2010, Office 2010, prevent, Protect Workbook Structure, Worksheet

Prevent automatic insertion of current date in Word

October 13, 2015 By Ravi Shankar 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.

Filed Under: MS Office, Word 2010, Word 2013, Word 2016 Tagged With: Date and time, Document, Insert, Modify, prevent, Word 2010

Prevent installing or uninstalling apps on iPad or iPhone

June 25, 2015 By Ravi Shankar 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.

Filed Under: Apple, iPad Tagged With: apps, Install, iPad 2, prevent, Remove, Uninstall

Primary Sidebar

Recent Posts

  • We have blocked all requests from this device – Firebase Phone Authentication
  • iPhone is not available error message in Xcode
  • Clear CocoaPods cache, re-download and reinstall all pods
  • PDFKit – View, Annotate PDF file in Swift
  • Tab Bar Controller with WebView

Archives

  • September 2020
  • April 2020
  • December 2019
  • November 2019
  • October 2019
  • February 2019
  • October 2017
  • June 2017
  • May 2017
  • March 2017
  • September 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • October 2013
  • August 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
  • March 2011
  • January 2011
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • July 2009
  • March 2008

Copyright 2020 © rshankar.com