+ Reply to Thread
Results 1 to 4 of 4

Restrict changing font

  1. #1
    Registered User
    Join Date
    06-24-2014
    Location
    Maldives
    MS-Off Ver
    2013
    Posts
    23

    Restrict changing font

    Hi,
    Can u guys please tell me how to restrict users from changing the font, format of the cells that are allowed to write on.
    Thank you.

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Restrict changing font

    Hi Statue.919- If you password-protect the sheet, you can restrict such changes. Go to Review ribbon and select Protect Sheet. It's pretty simple, just follow the instructions.
    (To unlock cells where text will be entered, right-click on them, select Format Cells..., select the Protection Tab, and un-check the Locked checkbox.

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee
    Last edited by leelnich; 05-28-2017 at 01:44 AM.

  3. #3
    Registered User
    Join Date
    06-24-2014
    Location
    Maldives
    MS-Off Ver
    2013
    Posts
    23

    Re: Restrict changing font

    Thank u for your reply.
    I have protected that way but when i copy something from another sheet to this sheet the font and format changes.
    I want a solution for this.
    Thanks in advance.

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Restrict changing font

    Withdrawn-LLN
    Last edited by leelnich; 05-28-2017 at 09:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to restrict user from changing the data
    By rviji.cbe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2015, 02:30 PM
  2. Replies: 1
    Last Post: 01-02-2015, 09:18 AM
  3. Changing VBA font?
    By balthamossa2b in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2013, 12:01 PM
  4. [SOLVED] Sheet Change Event Dubuggin: Restrict Cell Values toand Changing cells based on input
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2013, 02:37 PM
  5. How to restrict people from changing page layout
    By khokhart in forum Excel General
    Replies: 0
    Last Post: 11-07-2008, 02:02 AM
  6. how do i restrict users from changing my formulas
    By Help with formulas in forum Excel General
    Replies: 2
    Last Post: 07-27-2006, 06:00 PM
  7. [SOLVED] Restrict users from changing password
    By roel1973 in forum Excel General
    Replies: 3
    Last Post: 04-12-2006, 12:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1