人気ブログランキング | 話題のタグを見る

Color a Shape

I am trying to to assign a color to a Shape that is the same color as the background color of a cell.
 Code like:

ActiveSheet.Shapes("MyShape").Fill.ForeColor.SchemeColor = Range("A1").Interior.ColorIndex

does not throw an exception, but the assigned color is wrong.

Is there an easy way to assign SchemeColor values based on ColorIndex values?
Do I need a translation table?


I would like this to work on Excel 2007 and versions of Excel prior to 2007.

Solutions to the Problem Color a Shape

Download Error Fixer (Free)

SchemeColor was introduced in Excel 2007 so you can't use it in older versions.
Shapes don't have a ColorIndex property, so you should use the Color of the interior of the cell:
 
ActiveSheet.Shapes("MyShape").Fill.ForeColor.RGB = Range("A1").Interior.Color

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Recommended Method to Repair the Problem: Color a Shape:

How to Fix Color a Shape with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Cannot Download Flashplayer,Cannot Install Windows Update Error 8024A000,Cannot Display Website/ DNS/UNABLE TO CONNECT TO WEBSITE,Cannot Find Driver For Conexant AC-Link Audio Driver For Windows 7,Cannot Edit Hyperlink Using Alt F9,Cannot Open My Layout & Editing Program,Cannot Open XML Links In Excel 2010.,Cannot Open MSSQL$ACT7 Service Since Updating To Windows 8.1,Canon Zoom Browser EX Won't Work Error "Zb Module Has Encountered A Problem And Will Close",Cannot View Certain Pictures And Videos In Internet Explorer 8,Changing The Number Of Logical Processors.,CD Writer Not Functioning / Not Recognised By XP,Can’t Download Apps From Windows Store,Change What Programs Open When I Log Into My Computer,Checkbook Register Zero Colum Display
Read More: Fast Solution to Error: Check consistency message,Fast Solution to Error: Change what programs open when I log into my computer,Change cell color when if/then is true [Anwsered],Fast Solution to Problem: Change PC settings and Metro Apps Constantly Crashing\/Not Working.,[Anwsered] child's laptop is not able to connect to internet even though i have a westell wireless,Cannot display Chinese in the NotePad6.1 (Win 7),Cannot add favorites “Unspecified error”. - Cannot create a Favorites in a new folder,cant set yahoo mail as default using VISTA I downloaded and installedlatest messenger and toolbar,Cant boot into windows 8 after resizing primary drive.,Ccleaner, Malwarebytes does not open up
# by NoOutputDevice | 2016-09-19 17:26

Cannot receivve email from POP3 server on Outlook 2013

I was forced into moving into Windows 8 from Windows XP because my computer died.  Then I found out that none of my Office Software worked on Windows 8, now I am told by Verizon that Outlook 2013 does not work with POP3 servers.  Say it ain't so Joe! I
can receive by setting the incoming to incoming.verizon.net; but neither outgoing.verizon.net nor smtp.verizon.net work.  Is there a secret magic setting that I need?

Keys to the Problem Cannot receivve email from POP3 server on Outlook 2013

Download Error Fixer (Free)

Make Sure that your Hardware Meets the System Requirements

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Repair the Problem: Cannot receivve email from POP3 server on Outlook 2013:

How to Fix Cannot receivve email from POP3 server on Outlook 2013 with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.


Related: Batch Re-arrangement Of Excel Columns With Multiple Files,Black Screen Followed By Extremely Slow Boot, But No Entry In Event Log,Baixar Mfc.100dll,Bang Authenticate Dll Error - Receive Error Message: "Internet Explorer Cannot Display The Webpage",Black Screen And Restoring To Factory Settings,Browsers Are All Set To Unavailble And I Can Not Change The Default,C:\Users\MyName\Favorites\Favorites\Favorites\Favorites\Favorites\Favorites\Favorites\Favorites\...\Favorites Refers To A Location That Is Unavailable.....bla Bla Bla__,Calculate "Median" In Totals Row Of Pivot Table,Brightness Does Not Work After Downloading The New Windows 8.1 (ATIV Book 8),BSOD While Browsing With Chrome - Crash Address Ntoskrnl.exe+5a440,Can Someone Tell Me What The Different Is In Using A Subform In A Main Form Instead Of Creating A Form Outside Of The Main Form And Dragging It Into The Main Form?,Can I Uninstall IE10 Directly Back To IE8?,Can I Work With Excel Spreadsheets And Make Changes On Them On A Kindle Fire Or Ipad,Can't Get A Used To Part Of The Network PC Connect To Regular Internet At Home.,CAN'T DOWNLOAD ATTACHMENTS FROM EMAIL OR DOWNLOAD ANYTHING FROM A WEBSITE,Can't Install AutoCad 2009 On Windows 7 As It States Can't Install On This Version Of Windows,Can't Get Rid Of Network Place That Is Powered Off...?,Can't Pair Blueant X5i Wireless Headset With Windows Vista.,Can't Shut Down Windows 7,Can't Send Emails On Windows Mail --- Error 0x800CCC0B Comes Up
Read More: [Solution] Canon Digital Rebel XT 8MP EOS Digital Camera,Troubleshooting:Cannot send emails, error message 0x800ccc7d Error,cannot sign into widows messenger__,Troubleshooting Cannot see the Event log in Event Viewer for the Oepn Program Error,Fast Solution to Error Cannot Print Specific Excel File,Can you have Multiple security programs?,Can someone tell me how I can get rid of Microsoft Visual++++ Runtime error?,Can't boot up on Windows 8 recovery disks,can you read this minidump file please?,Can't Find Windows Fax and Scan
# by NoOutputDevice | 2016-09-14 11:41

can't login to Windows live from W7 IE8 laptop.

can't login to windows live (mymsn, hotmail, etc.) on W7 IE8 laptop.  All other computers can log in with a variety of configurations.  Is there some default security/access setting that changed?

Anwsers to the Problem can't login to Windows live from W7 IE8 laptop.

Download SmartPCFixer for Free Now

Hi,
·         Are you getting this error when you are attempting to sign in to Windows Live?
·         Are you able to login and access other websites?
You may try optimizing the Internet Explorer and then check what happens.
“How to optimize Internet Explorer”http://support.microsoft.com/kb/936213
Also refer to “You cannot log in to or connect to secured Web sites in Internet Explorer”http://support.microsoft.com/kb/813444
Diana
Microsoft Answers Support Engineer
Visit ourMicrosoft Answers Feedback Forum and let us know what you think.

If this post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of this message.
By marking a post as Answered, or Helpful you help others find the answer faster.

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve can't login to Windows live from W7 IE8 laptop. in Windows.

  1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
  2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
  3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
  4. Close the Command Prompt Window because we are done.

Try and see if you still get the same error can't login to Windows live from W7 IE8 laptop. in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Recommended Method to Repair the Problem: can't login to Windows live from W7 IE8 laptop.:

How to Fix can't login to Windows live from W7 IE8 laptop. with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed


Related: Being Blocked With My Email,Bad Directory Name When Trying To Install A Program.,Bckgzm.exe-system Error: The Program Cant Start Because Opencl.dll Is Missing From Your Computer.try Reinstalling The Program To Fix This Problem.,BAD_POOL_HEADER ERROR - WINDOWS 8,BIOS, Checksum, .NET Framework Or Registry Errors. Having Problems With All. Help,Can't Find Out How To Get Rid And Search For Anything Else Using Internet Explorer On Windows 8.1.,Can't Boot Into Win 7 X64, BSOD (system_service_exception, STOP: 0x000003B), Seems To Be Related To Win32k.sys,Can You Insert Dashes Into A Number Sequence?,Can You Modify Value Field Colum Settings In Pivot Table To Delete The "sum Of" Or "count Of" And Just Have A Single Word For The Data?,Can't Find Account Picture
Read More: Troubleshooting:Can't access Portfolio Manager.,Fast Solution to Problem: Can no longer browse to save export flat file to a specific location.,How to Fix Problem - Can not download file - others can.?,Solution to Error: Can List Styles be based on Normal?,How to Resolve - Can you print two or three spreadsheets on the same page. All spreadsheets are in the same workbook.?,Can anyone help me troubleshoot this "no network/internet access" problem?,can't display Windows or Microsoft Updates Page any more with IE8,Can not recieve e-mail The connection to the server has failed.,can't download windows update, can't install service pack 1,Can not print to a network printer from IE7
# by NoOutputDevice | 2016-09-08 12:46

Can I download the Windows Media Player plugin for Google Chrome?

Hi there

 I would really appreciate it if you could tell me if I can download the Windows Media Player Plugin for Google Chrome using windows 7 64 system home edition.

Kind Regards
Jan
Original title: Just wondering:???????????????????

Anwsers to the Problem Can I download the Windows Media Player plugin for Google Chrome?

Download SmartPCFixer for Free Now

Hi,
 
Yes that should work ok.
 
Install Windows Media Player
If a page simply links to Windows media files (e.g.
.asf or .asx files), you might not see a prompt to download the Windows Media Player plug-in.
In that case, follow these instructions to get the plug-in:
Windows instructions

Visit
http://www.interoperabilitybridges.com/wmp-extension-for-chromeClick Download Now.Click Save for the file in the downloads bar to confirm that you want to download the file.
Don't worry -- saving the file won't harm your computer.
Learn more about

downloading files in Google Chrome.Open the set-up file.Click Run to start the Setup Wizard.
Follow the instructions in the wizard to finish installing the plugin.Restart Google Chrome.
Kind regards,
Joel

Manually editing the Windows registry

Caution: Unless you an advanced PC user, please do not edit the Windows registry manually.

Because of this risk, we highly recommend using a trusted registry cleaner such as SmartPCFixer Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your MACHINE_CHECK_EXCEPTION error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors can also dramatically improve system speed and performance.

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.

Recommended Method to Repair the Problem: Can I download the Windows Media Player plugin for Google Chrome?:

How to Fix Can I download the Windows Media Player plugin for Google Chrome? with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: How to Update ASUS Xonar D2X driver for Windows XP 32/64-bit,Update ATI VGA Driver version 6.13.10.5779,How to Download Chicony Camera Driver version 61.005.029.1900,Download OKI C9800(PCL),How to Update TI Card Reader Driver version 2.0.0.10,Method to Download Toshiba Portege R835-P83 eco Utility v.1.3.21.0 driver,Method to Download Toshiba Satellite A660-BT2N23 Face Recognition v.3.1.3 driver,Download Toshiba Satellite L355-S7907 Face Recognition v.2.0.17.32 driver,[Solved] Download Toshiba Satellite L740-BT4N11 PC Health Monitor Utility v.1.7.9.64 driver,How to Download Toshiba Satellite P305D-S8828 WPS Library v.1.0.0.7 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Troubleshooting:Can I install a program from disc on windows 8,How Can I Fix - Can I have a password for a Microsoft Office 2010 Folder?,Can i get back hiberfil.sys and pafefile.sys?,Solution to Problem: Can I have a wireless router on my computer?,Can I add Access to my Office Small Business 2007 Tech Support,BSOD after upgraded to Windows 8.1 (memory problem?),Blurry programs on Windows 8.1,C:\Window|Microsoft.Net\Framework\v4.0.30319\mscoreei.dll could not be loaded,Browsing history is no longer visible,Bulk deleting from email deleted items folder
# by NoOutputDevice | 2016-08-26 15:19

Blue Screen (BSOD) After System Image Restore - Windows 7

I backed up my old system before sending it in for repairs.
They replaced the HDD and sent me back the refurbished PC.
So I started to restore my old system to the same computer.
I put in the repair disc I just made on the new OS they put on the new HDD
(Home Premium).
I went to system image restore, and it recognized the system image etc. on my external HDD.
I checked to format & repartition, etc.
so it set about restoring the system, it took about 3 or 4 hours for 315 or so GB.
(my external HDD is 320GB,
but the computer HDD is 640GB)
 
When it was done it restarted and ran CHKDSK (I wouldn't skip it even if I pressed a button).
It fixed a few things and restarted.
Then it said "Starting Windows" or whatever, and the BSOD.
It says:
 
*** STOP 0x000000F4 (0x0000000000000003, 0xFFFFFA800701A060,0xFFFFFA800701A340, 0xFFFFFA80003393460)
 
Please help, thank you!

Anwsers to the Problem Blue Screen (BSOD) After System Image Restore - Windows 7

Download SmartPCFixer for Free Now

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Recommended Method to Fix the Problem: Blue Screen (BSOD) After System Image Restore - Windows 7:

How to Fix Blue Screen (BSOD) After System Image Restore - Windows 7 with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Big Disconnect Between Outlook 2013/Outlook.com/WP8 Calendar,Battery Problem.it Hibernates When More Than 50% Battery Is Remaining?,Black Screen After Update From Windows 8 To Windows 8.1.,Black Bar Down The Side Of My Internet Page.,Because Of Your Security Setting Micro Has Been Disabled
Read More: How to Resolve - Bad Connection?? - My connection has slowed down an incredible amount?,BCCode: 9f BSOD [Solved],How to Fix - Bluescreen with BCCode:50 error?,How to Fix - blue screen - Stop Error 0x0000008E (0xC0000005, 0x8BD51487, 0x9E1B9B9434, 0x00000000)?,How to Fix - Blue screen crash after downloading security update.?,BAD_POOL_Header with USB Memory stick,being told to download microsoft framework.net, I don't know which version it is needing, i have downloaded several but....,BAD_POOL_HEADER C:\WINDOWS\system32\ntoskrnl.exe,Bing rewards won't save my contact information,battery plugged in not charging
# by NoOutputDevice | 2016-08-10 17:37