+ Reply to Thread
Results 1 to 6 of 6

Removing Black Spaces

  1. #1
    Registered User
    Join Date
    08-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2000/2007
    Posts
    30

    Removing Black Spaces

    Hi Everyone,

    I was just informed on my last post that removing passwords is against the rules. I apologize, I thought I had got a password reset tools years ago from this site but maybe I am mistaken. Anyways, I was able to get the password sheet from my brother and unlock this document that we did in fact pay for. He ended up finding his password in an old email he no longer uses. I removed the workbook protection but the fields are all still black. Anyone know of a way or can anyone fix this file for me? I would like to remove all the black fields that limit this from being used. The document should be unlocked now.

    Thank you,

    Fish
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Removing Black Spaces

    Reading this over it sounds like this "subscription" has expired, and you need to pay them to unlock it for you.
    with that being said there is always a way to do it, but for ethical reasons i will not share this info.

  3. #3
    Registered User
    Join Date
    08-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2000/2007
    Posts
    30

    Re: Removing Black Spaces

    Yes the subscription expired back in 2015 and the employee who built this and sold it to us no longer works at the company. It was almost three years ago and I was told they no longer offer this service so no one else to contact.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Removing Black Spaces

    There is no issue here with subscriptions or passwords or locking.

    Go to Conditional Formatting and delete all of the rules that cause cell fill color to be black. This is set up on many of the worksheets.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  5. #5
    Registered User
    Join Date
    08-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2000/2007
    Posts
    30

    Re: Removing Black Spaces

    Thank you so much 6StringJazzer appreciate it! I had no clue where to even begin looking on to figure this out.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Removing Black Spaces

    You're welcome!

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationicon.jpg below their name.

+ 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. [SOLVED] Removing spaces
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-29-2015, 02:46 PM
  2. Removing black border around active cell
    By cenky in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-16-2014, 12:33 PM
  3. Replies: 1
    Last Post: 04-25-2014, 07:44 PM
  4. Removing spaces
    By davidx in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-15-2013, 05:43 AM
  5. Rows/collumns freeze - Removing black line
    By kayard in forum Excel General
    Replies: 0
    Last Post: 12-15-2011, 12:48 PM
  6. Excel 2007 : removing spaces
    By bjamin_w in forum Excel General
    Replies: 4
    Last Post: 02-19-2010, 09:04 AM
  7. Need:removing spaces
    By kcm in forum Excel General
    Replies: 4
    Last Post: 06-01-2005, 11:49 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