2016년 7월 6일 수요일

auto adjust a cell to the size of the text that it contains [Anwsered]

auto adjust a cell to the size of the text that it contains

I have a situation where a text of a cell varies (because if formulas and references) , however since i have Wrapped that Cell, the entire content (text) is not showing up.  and i cant manually double click on the row to show the entire text because the
sheet (that particular cell) is protected.
Now how do i set or format that cell so every time any text (irrespective of its characters) it is refereed  that cell should show up the entire text which of-course will vary.

Any help on this question will be real help..

Keys to the Problem auto adjust a cell to the size of the text that it contains

Download SmartPCFixer to Fix It (Free)

There is a way to do this using VBA code / macro, eg if cell E8 is the cell to change then the following in a macro would readjust the height of that cell...
ActiveSheet.Range("E16").UseStandardHeight = True
There does appear to be a limit to cell height of 546 pixels, so as long as that is not exceeded this would work.
To use it in a macro that would work for you though, a little more detail would need to be known about the sheet and when / how often the cell size should be checked.
You mention that the sheet is protected, so you would also need to know / own the protection
for this to succceed.

Boot in Safe Mode:

  • Open Run command as previously described
  • Type MSConfig
  • Click on Boot tab
  • Tick Safe boot in Boot option
  • Select Network
  • Click Apply and OK
  • Reboot your system

Your system will boot in Safe mode with Networking. You may now try and open Windows Store and should not see any errors.

Recommended Method to Repair the Problem: auto adjust a cell to the size of the text that it contains:

How to Fix auto adjust a cell to the size of the text that it contains with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the list.

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Solution to Error: Back and Forward Buttons Don't Work in IE10,Troubleshooter of Error: Are there any features which are supported only in MS Word 2010 and 2013 but not in 2007 version?,Fast Solution to Error: ASUS S400CA driver power state failure HELP (with DMPs file attached),[Solution] Audio output device driver fails,Fast Solution to Error: Back quote character repeats itself,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

[Solved] average if multiple conditions are met

average if multiple conditions are met

I am working on a loading calc.
sheet for a wastewater plant.
I have pages set up for each month (tabbed) and an annual loading on the last tab of my workbook.
In doing my sheets I have so far accomplished only averaging if >0.
This part works fine but I
get the #DIV/0 in my cell if there are no numbers >0 which messes me up on the annual loading page - the monthly page does fine as long as I have at least 1 # >0.
Here is my formula that I am currently using:
=AVERAGEIF(I4:I34,">0")*G35
I4:I34 is my Total Nitrogen
G35 is my # of days discharged
So the formula takes my average, as long as it's >0 and multiplies it by the number of days I have discharged for the month.
How can I add to this formula to have any "0"  values that I have show up as a "0".
I hope I have explained this well and will be glad to try to give further info if it will be helpful.
Thanks for your time.
Greg

Anwsers to the Problem average if multiple conditions are met

Download Error Fixer for Free Now

...
but I get the #DIV/0 in my cell if there are no numbers >0 which messes me up on the annual loading page ...
How can I add to this formula to have any "0"  values that I have show up as a "0" ...

You could add 0 values into the AVERAGEIF() criteria or take advantage of the newer IFERROR() function to wrap around your AVERAGEIF() and default to
0 if a #DIV/0 will result.

=AVERAGEIF(I4:I34,">=0")*G35
...
or,
=IFERROR(AVERAGEIF(I4:I34,">0"),0)*G35
...
or,

=IFERROR(AVERAGEIF(I4:I34,">0")*G35,0) 

I believe one of the latter two formulas is going to be closer to what you want to accomplish, i.e.
never include
zeroes in the average.


AVERAGEIF function

IFERROR function

Manually editing the Windows registry to fix Error average if multiple conditions are met

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

  • 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.

Another Safe way to Repair the Problem: average if multiple conditions are met:

How to Fix average if multiple conditions are met with SmartPCFixer?

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

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: How to Fix - Auto correct word 2010?,Average with multiples if's, need to add an or [Anwsered],Troubleshooting:auto set print area on range that changes,Tech Support: Autofill with data validation,Fast Solution to Problem: Attaching photos,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

[Anwsered] Asus laptop won't sleep

Asus laptop won't sleep

*I posted this question in Yahoo Answers days before.
Unfortunately there was no useful answer.


Laptop: Asus K45VM
OS: Windows 7 Home Basic 64 bit
Everytime I close the lid, my laptop would not enter sleep.
I could see it's still on because the indicator light at the bottom stays on.
- I already set all the power profiles: Power Options > Multimedia Settings > When Sharing Media >
Allow the computer to sleep
- Updated both my integrated and discrete graphics' drivers
- Update Windows regularly
- "Sleep when the lid is closed" is enabled
Even when it was new (fresh, barely anything installed), sometimes it would sleep, sometimes not.
-
One thing I did try earlier is to run cmd.exe, Run as administrator, and then entered "powercfg -availablesleepstates"
The result is this ->  

...which I have no idea how to solve.

Keys to the Problem Asus laptop won't sleep

Download Error Fixer for Free Now

Hi,
 
Does the laptop sleep when you choose the option to sleep other than closing the lid?
 
 
Follow these methods and check if it helps:
 
Method 1: First, I would suggest you to run the Power troubleshooter.
Open the Power troubleshooter
http://windows.microsoft.com/en-US/windows7/Open-the-Power-troubleshooter
 
Method 2: You may also try creating or changing power plan.
a.
Open Power Options by clicking the Start button, clicking
Control Panel, clicking System and Security, and then clicking Power Options.
b.
Under the current power plan, click Change plan
settings.
c.
On the Change settings for the plan page, click on
Change advanced power settings.
d.
Adjust the sleep options in advanced power settings and check.
 
Method 3: You can restore power setting to default by executing the command from an elevated command prompt.
Open the Command Prompt window by clicking the
Start button, clicking All Programs, clicking Accessories, right click on Command Prompt, and then select
Run as administrator.
Type the following command in command prompt and press enter.
powercfg.exe –restoredefaultschemes
 
 
For more information, refer to this article:
About how to troubleshoot power plans in Windows 7
http://support.microsoft.com/kb/980869/en-us
Note: Modifying BIOS/complementary metal oxide semiconductor (CMOS) settings incorrectly can cause serious problems that may prevent your computer from booting properly.
Microsoft cannot guarantee that any problems resulting
from the configuring of BIOS/CMOS settings can be solved.
Modifications of the settings are at your own risk.
 
 
Let us know if it helps.  If that does not help, please reply and we would be happy to help you.

Run CHKDSK
  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Reboot your computer.

Recommended Method to Repair the Problem: Asus laptop won't sleep:

How to Fix Asus laptop won't sleep with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will perform a scan for your system. 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 Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Autochk pauses 30 sec during bootup, after adding WD HDD to Win 7-64 SSD system,[Solved] At boot up - EIO CAN'T LOAD dialog box,How to Fix Error - Auto spell check stops working after document grows to a certain number of words.?,Troubleshoot:Auto Number\/ Auto Fill Error,How to Fix Error - Backup failure – “There was a failure in creating a directory on the backup storage location. Details: Access is Denied. Error Code: 0x8078014B”?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Backup Hard Drive filling up with a Huge System Volume Information File, but backups are set to manual? [Anwsered]

Backup Hard Drive filling up with a Huge System Volume Information File, but backups are set to manual?

I noticed that the first hard drive that came with my laptop was slowly filling up though I was not adding any new files to it: at the time I was running Windows Vista.
I made the Upgrade to Windows 7 and grabbed a new hard drive to copy all my data over,
reformatted the old one to use as backup and Storage of Music and etc.
The first hard drive is now my backup drive, and the main hard drive is what I run programs on/install programs to.
My system protection settings are set to manual, and I only have two
system restore files at any given time.
One from when I first upgraded, and a new one whenever I install large program or fix an issue.
Yet somehow, the :\SytemVolumeInformation file on the backup drive continues to grow, and is beginning to seriously impact
the amount of space I have left on the hard drive (100/500 GB).
Some may not consider this to be so bad, but I do music mixing and the backups I've learned to make of the sound libraries I use in order to not waste a day reloading them all are relatively tiny
overall, except that I have quite a few.
The total amount of everything on the hard drive apart from the file comes to just over 310GB, while the new hard drive has just over 70/320GB.
Ordinarily I wouldn't worry about this except that the SystemVolume File
keeps growing   at a rather alarming rate. 
I discovered this growth while using Piriform Defraggler, and comparing the logs I had between one week and the next, over the course of a month where I have added nothing to either drive, the file has grown substantially larger everyday, but not really
in a pattern.
It went from 34GB, which I could understand, to roughly 80, which I cannot, over two weeks, and now another 20 GB in a week.
My Music libraries are not backed up by System Restore, so I cannot think of them being responsible for this huge file.
If anyone can explain to me why this is happening, even if there is no way to fix it, I would greatly appreciate it.

Keys to the Problem Backup Hard Drive filling up with a Huge System Volume Information File, but backups are set to manual?

Download Error Fixer for Free Now

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Another Safe way to Repair the Problem: Backup Hard Drive filling up with a Huge System Volume Information File, but backups are set to manual?:

How to Fix Backup Hard Drive filling up with a Huge System Volume Information File, but backups are set to manual? 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 which need to be repaired.

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Fast Solution to Problem: Averageif date is less than today,Are Word Master Documents less corruptible in Office 2010? [Anwsered],[Anwsered] ATI Moblility Radeon HD 5000,Troubleshooting:Avg. Disk Queue Length is 2. The disk may be at its maxium transfer capacity due to throughput and disk seeks Error,Troubleshoot:Are there updates for flight sim 2002?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

[Solved] average if multiple conditions are met

average if multiple conditions are met

I am working on a loading calc.
sheet for a wastewater plant.
I have pages set up for each month (tabbed) and an annual loading on the last tab of my workbook.
In doing my sheets I have so far accomplished only averaging if >0.
This part works fine but I
get the #DIV/0 in my cell if there are no numbers >0 which messes me up on the annual loading page - the monthly page does fine as long as I have at least 1 # >0.
Here is my formula that I am currently using:
=AVERAGEIF(I4:I34,">0")*G35
I4:I34 is my Total Nitrogen
G35 is my # of days discharged
So the formula takes my average, as long as it's >0 and multiplies it by the number of days I have discharged for the month.
How can I add to this formula to have any "0"  values that I have show up as a "0".
I hope I have explained this well and will be glad to try to give further info if it will be helpful.
Thanks for your time.
Greg

Anwsers to the Problem average if multiple conditions are met

Download Error Fixer for Free Now

...
but I get the #DIV/0 in my cell if there are no numbers >0 which messes me up on the annual loading page ...
How can I add to this formula to have any "0"  values that I have show up as a "0" ...

You could add 0 values into the AVERAGEIF() criteria or take advantage of the newer IFERROR() function to wrap around your AVERAGEIF() and default to
0 if a #DIV/0 will result.

=AVERAGEIF(I4:I34,">=0")*G35
...
or,
=IFERROR(AVERAGEIF(I4:I34,">0"),0)*G35
...
or,

=IFERROR(AVERAGEIF(I4:I34,">0")*G35,0) 

I believe one of the latter two formulas is going to be closer to what you want to accomplish, i.e.
never include
zeroes in the average.


AVERAGEIF function

IFERROR function

Manually editing the Windows registry to fix Error average if multiple conditions are met

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

  • 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.

Another Safe way to Repair the Problem: average if multiple conditions are met:

How to Fix average if multiple conditions are met with SmartPCFixer?

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

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: How to Resolve - Attachments automatically open when opening an email?,How to Resolve - Assigning Drive Letters to Thumb Drives?,How to Resolve - AutoPlay for External Hard Drive Opens when Windows Boots to Desktop?,AVerMedia A336 MiniCard Hybrid DVB-T driver,AutoComplete for Web addresses - Works for \"http:\\\\www.google.com\" but not for \"google.com\" Tech Support,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

How to Fix Error - Auto Run Module.bas on Excel, HOW??

Auto Run Module.bas on Excel, HOW?

Hi, can anybody help me? I'm having a problem on macro,
whenever i open excel 2007 I always have to open the module.bas to make a program run, even when I save it as Macro-enabled worksheet.
I always have to ALT+F11 and insert module for it to work,
Is there anyway to make it easier or make it auto-run on opening that file.

thanks.

Solutions to the Problem Auto Run Module.bas on Excel, HOW?

Download SmartPCFixer for Free Now

If you create a sub in a normal module called Auto_Open then Excel will run that when you open the workbook.
But the preferred way is to use the ThisWorkbook module and put this code in there:
 
Private Sub Workbook_Open()
'Your code goes here
End Sub
You can get the stub of code by first opening the Thisworkbook module and then clicking on the left-hand dropdown at the top of the code window and selecting "Workbook".
Note that the right-hand dropdown lists several other useful events.

Windows Error Reporting - To Fix Auto Run Module.bas on Excel, HOW?

  1. Go to Start button.
  2. Open Control Panel.
  3. Go to Windows Error Reporting.
  4. Click on System and Maintenance, then click Problem Reports and Solutions.
  5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
  6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
  7. Next, click the Advanced settings link.
  8. Select Off to turn off Error Reporting.

Recommended Method to Fix the Problem: Auto Run Module.bas on Excel, HOW?:

How to Fix Auto Run Module.bas on Excel, HOW? with SmartPCFixer?

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

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

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: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Fast Solution to Error: Autoplay stopped working suddenly in my computer for USB devices.,Fast Solution to Error: Arrow keys moves the scroll bar while playing flash games.,Troubleshooting:Automatically inserting blank rows Error,How to Fix Error - Automatic Hibernation Fails Even Though Manual Hibernation Works?,[Anwsered] Back up error in vista...how do I fix it?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Troubleshoot:assuming error message ntldr is missing press alt ctrl del to restart

assuming error message ntldr is missing press alt ctrl del to restart

Getting up this morning the other half asked if internet was working both my kindle and laptop connected no problem.
But our ancient home computer was having an issue checked the connections told me connection was disabled I tried to enable it with no
luck while looking around on screen I noticed icon didn't recognize a search protection something I went into add/delete programs and removed it it then told me need to restart computer on doing that I received the fabulous error message.
This is older computer
we basically use just for looking up stuff and the occasional game of chess.
I have read the other posts and frankly they confused the **** outta me no laughing plz :) anyways I hope someone can help me with explanation of what to do for computer dummy.
Thanks
so much

Solutions to the Problem assuming error message ntldr is missing press alt ctrl del to restart

Download Error Fixer for Free Now

Tweak IE Options
  • Open Internet Explorer.
  • Go to "Tools > Internet Options > Advanced Tab".
  • Uncheck "Enable third-party browser extensions".
  • Click "Apply".
  • Reboot your computer.

Recommended Method to Fix the Problem: assuming error message ntldr is missing press alt ctrl del to restart:

How to Fix assuming error message ntldr is missing press alt ctrl del to restart with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: How Can You Fix - autodata 3.38 runtime error 217 at 004BB10D?,Fast Solution to Error: AutoRecovery in Word Starter 2010????,How to Fix Problem - Are there settings I can change either on my computer or in Windows Live so it runs faster??,Solution to Error: Backup and Restore Problem in Vista HP-64,Fast Solution to Problem: automatically reordering sheets in workbook,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Fast Solution to Error: Auto generate table of contents in excel workboooks.

Auto generate table of contents in excel workboooks.

What is the code to have excel create a table of contents in two different ways.
 
1-based on the worksheet tab name.

 
2- based on the value that is in a cell or multiple cells

Solutions to the Problem Auto generate table of contents in excel workboooks.

Download SmartPCFixer to Fix It (Free)

You could set it up this way...

Function DoItMyWay(ByRef blnTabs As Boolean, _
             Optional ByRef objList As Excel.Range) As Boolean
 If blnTabs Then
    Call CreateTabListing
    DoItMyWay = True
 ElseIf Not IsMissing(objList) Then
    Call CreateListFromRange(objList)
    DoItMyWay = True
 Else
    DoItMyWay = False
 End If
End Function
'---
Jim Cone
Portland, Oregon USA
free & commercial excel programs

Using Windows troubleshooter:

  • Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
  • A new window will open. Click View all from the left pane.
  • Scroll down to the bottom and click on Windows update.
  • Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
  • The troubleshooter will automatically detect problems and fix it.
  • Now, close this window and try download/install the app which was previously showing error.

Another Safe way to Fix the Problem: Auto generate table of contents in excel workboooks.:

How to Fix Auto generate table of contents in excel workboooks. with SmartPCFixer?

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

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshooting:Audio\/Video out of sync watching netflix or streaming videos Error,How to Fix Problem - backup on 2nd PC not seeing networked shared drive on 1st PC?,backup and restore- clicking on \"change settings\" and \"manage space\", no response [Anwsered],Troubleshooter of Error: ATL100.dll is missing from computer. is it part of Dell Dock. it appeared after office update said it had to close some programs,[Solved] at a condo away from home. I can receive mail but can not send,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?

Solution to Error: Auto-Run will not work in Windows 7, checked settings for optical drive

Auto-Run will not work in Windows 7, checked settings for optical drive

Although I've gone into the settings for my optical drives, my "Auto-Run" doesn't work.  Am I missing something?

Anwsers to the Problem Auto-Run will not work in Windows 7, checked settings for optical drive

Download Error Fixer (Free)

Hi,
Was it working fine before? Did you make any software or hardware changes on your machine prior to this issue?
Let’s follow these methods and check if the issue persists.
Method 1
a.
Type "services.msc" in the start search box, click on OK.
b.
When the Services window loads, navigate to the "Shell Hardware Detection" service, the double click on it to open it.
c.
Make sure the "Startup Type" says "Automatic".
If it doesn't, use the drop down menu to change it.
Method 2
Alternatively, you may also hold down the Shift key when you insert devices or media into your computer to open AutoPlay, regardless of the default setting.
Method 3
You may create a new user account with administrative privilege and check if the issue persists.
Create a user account
If you don’t have any issue in the new user account, access the link below and follow the steps to fix a corrupted user profile:
http://windows.microsoft.com/en-US/Windows7/Fix-a-corrupted-user-profile
Refer: Troubleshoot AutoPlay problems

Using Windows troubleshooter:

  • Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
  • A new window will open. Click View all from the left pane.
  • Scroll down to the bottom and click on Windows update.
  • Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
  • The troubleshooter will automatically detect problems and fix it.
  • Now, close this window and try download/install the app which was previously showing error.

Another Safe way to Repair the Problem: Auto-Run will not work in Windows 7, checked settings for optical drive:

How to Fix Auto-Run will not work in Windows 7, checked settings for optical drive with SmartPCFixer?

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

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

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


Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: How to Fix Problem - Auto Recovery loop on Windows 8?,How to Fix - ayuda; muy muy importante para mi?,How Can I Fix - Back up crashes after 45 min. says error, but now there is no code.?,[Anwsered] autoplay does not work and i have tried solution i have found. I am so frustrated. Windows 7,Background Processes!! [Solved],application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?