+ Reply to Thread
Results 1 to 5 of 5

coding for unprotect sheet and cell fill with default colour

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    coding for unprotect sheet and cell fill with default colour

    Hi
    I sincerely thank from bottom of heart the forum for various solutions for vba coding for various automation and easying in terms of time saving.
    I am in need of a help.
    I am working acccounts department with figures thrown as Trial balance from the system.
    The sheet is by default protected and auto filled with colour.
    Every time while consoldating we do
    1)unproetect sheet by going to review menu and
    2) we go to format menu for choosing default fill colour no colour of
    3)We do demerge the cells for the heading.
    We do this activity for each and every work books
    Can you please help to automate this process.
    We do about 50 and 100 sheets every day.
    Please help
    We attch the excel and and result sought in the in different work sheets.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: coding for unprotect sheet and cell fill with default colour

    Hi
    Any help on this Please
    Thanks & Regards
    N.Srinivasan

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: coding for unprotect sheet and cell fill with default colour

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Re: coding for unprotect sheet and cell fill with default colour

    Hi
    It works fine.
    I thank you very much from my bottom of my heart.
    It relieves me a lot of pain
    Thanks & Regards
    N.Srinivasn

  5. #5
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: coding for unprotect sheet and cell fill with default colour

    You are very welcome.

+ 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. Replies: 6
    Last Post: 04-11-2016, 09:48 AM
  2. To fill entire row with fill colour of a particular cell with a formula
    By shailendra chari in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 11-30-2013, 11:18 AM
  3. Replies: 1
    Last Post: 09-12-2013, 02:09 PM
  4. Unable to create VBA coding to automatically generate averaged fill colour of a text box
    By zero_eclipse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2012, 07:45 AM
  5. Fill Colour of a cell based on another cell Fill Colour
    By ConorK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2012, 07:09 AM
  6. colour coding cell based on value of another
    By Brontosaurus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2010, 09:42 AM
  7. How to copy cell content and fill colour from sheet1 to another sheet
    By cooltalgat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-16-2010, 11:41 AM

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