Over 1 million tech questions and answers.

negative view of macros!

Q: negative view of macros!

with excel 2002 is there any way of limiting a value to positive numbers?
perhaps in the dim area?
i have a value defined as range - whatever that means!

Preferred Solution: negative view of macros!

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: negative view of macros!

Read other 16 answers

My Excel file closes by itself when trying to view macros.

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Enterprise, 64 bit, Build 18363, Installed 20191127182037.000000-240
Processor: Intel(R) Core(TM) i5-8365U CPU @ 1.60GHz, Intel64 Family 6 Model 142 Stepping 12, CPU Count: 8
Total Physical RAM: 16 GB
Graphics Card: VNC Mirror Driver
Hard Drives: C: 237 GB (171 GB Free); D: 931 GB (789 GB Free);
Motherboard: Dell Inc. 0PD9KD, ver A00, s/n /B67Q2R2/TW3207098N0177/
System: Dell Inc., ver DELL - 1072009, s/n B67Q2R2
Antivirus: McAfee VirusScan Enterprise, Enabled and Updated

Read other answers

I am converting an old MS Word template we have for our office to install properly on 64 bit systems which basically just inserts some small preformatted .doc files into a template which you can save as a new file. All I did was change the lookup for the file location to grab the program files environment variable so it would go to Program Files or Program Files (x86) when it should.

Now the issue I'm seeing is that the toolbar it places provides shortcuts for 10 or so of these inserts and 9 of them work. The last one gives the error "The macro cannot be found or has been disabled because of your Macro security settings". This error popped up on all these shortcuts before I dropped macro security settings down to medium, after which the rest of them worked just fine. If I go to tools->Macros->Macros to see the list of available macros I can run it directly from there and it works just fine.

The problem insert has no different code at all (except for the filename which it inserts), but is the only document to have a picture within it if that helps. I'm not very familiar with word or the macro editor within it but I was not able to find a way to edit the toolbar that appears in 2003 (Which is not present in 2007).

Some extra info: I am seeing this issue on a win8 64 bit laptop running office 2003. On my other laptop I have office 2007 and do not have the toolbar shown in 2003 at all. The toolbar issue may be present there but I have no idea how to e... Read more

Read other answers


(WinXP, Office 2000)
I have a macro that changes all formulas into values, deletes all modules in VBA and then saves workbook.
How do I save and close the workbook without the macro that does the above
Whatever I try always leaves that one macro and when I close the new workbook it asks me to save changes even though i have already given command to save:

ActiveWorkbook.VBProject.VBComponents.Remove ActiveWorkbook.VBProject.VBComponents("Module6")
ActiveWorkbook.VBProject.VBComponents.Remove ActiveWorkbook.VBProject.VBComponents("Module7")
ActiveWorkbook.VBProject.VBComponents.Remove ActiveWorkbook.VBProject.VBComponents("Module9")

ThisWorkbook.VBProject.VBComponents("ThisWorkbook").CodeModule.DeleteLines 1, 22 Set vbCom = Application.VBE.ActiveVBProject.VBComponents

vbCom.Remove VBComponent:= _
Set vbCom = Application.VBE.ActiveVBProject.VBComponents

vbCom.Remove VBComponent:= _

Application.DisplayAlerts = True
Application.ScreenUpdating = True
ActiveWorkbook.Close savechanges:=True

ActiveWorkbook.Close savechanges:=True



A:macro that deletes all macros and saves workbook clean of macros

Hi, welcome to the board.

Not really something that I know anything about. What you have already refs ThisWorkbook module -- maybe it's to do with "You cannot delete the ThisWorkbook object module, or a sheet object module, or a chart object module"

(http://www.cpearson.com/excel/vbe.htm , 1/3-way down)

Read other 1 answers

I have a report that contains macros to update all the information that is put in. It is in excel 97 and my business just recently updated to 2003 and now I get a compile error when I run the reports. How can I fix this error?

A:Solved: convert excel 97 macros to excel 2003 macros

Read other 8 answers

I have an excel file that look like the photo below

I need hyperlink each box (A, A1, A1a...B4) to a new excel file. Therefore if I click on A, a blank excel file will open. I have to hyperlink hundreds of these boxes on the excel file I am working on and is very time consuming to do so.

I was wondering if it was possible to create a macros to automate the creation of a hyperlink and that hyperlink leading to a blank excel file.

I do not care what the title of the new excel file is named. What I care about is that all of the new excel files go to a specific folder.

A:Excel Macros - New to macros. Please help

Read other 6 answers

Any negative impacts. So have a go at gobbling up it in the wake of examining the underneath audit all things considered. slim foria fixings The real component settling utilized as a bit of this slim foria supplement is slim foria with a social affair of ..

Read other answers

I'm downloading a decently large file (2.50 GB) and it's in the Negative percent, the download bar (little blue bars that go across) are all the way across, I have 160 MB of 2.50 GB downloaded, and it says 4 hours and 10 mins left, and it also says -11% as the percent complete, what does this mean??

Thanks ^.^

A:Negative % in download??

What it means is fairly straight forward. Of the huge download, only 11% has been downloaded and 11% of 2.5GB is about 160mb. It is estimated to take 4 hours to download such a large file. If you are on dial-up, it might take that long! On DSL or cable, it should not take that long. Does that answer your question?

Read other 2 answers

I am getting a negative effect on any picture i get on my computer. Either emailed, uploaded, downloaded etc. I currently am running windows 95, my computer is set at 32 bit color ( changed from 256( no effect on anything)). My desktop folders also have the negative effect. Can someone please help. Is this a resolution problem? Can this be fixed in safe mode? Dis i change the display to something it should not be at? help please. I have been trying to fix this for weeks.

A:negative effect

Is this perchance a Laptop?

"The negative effect" I assume you mean the colors are backwards, white is black, green is purple, etc, etc

If this is the case there should be a strange key on your keyboard that looks like a white A and a black A. Usually you hit the function key then hit the other reverse key to change the colors around.

Otherwise... you will need to find your video card settings and mess around with the gamma section majorly.


Read other 2 answers

Hello. Please let me know how to make Excel work so that

A1=B, then the number I put in is positive
A2=D, then the number I put in becomes negative automatically, in red font


A:IF and negative numbers

Read other 16 answers

Hi, I do not pretend that I have a serious problem with Windows 7 Home Premium 64-bit.
Every time I start my computer I get a low pitched negative sounding noise which repeats 2 or 3 times. It is a little annoying as I feel something is wrong. The only thing that has changed is when I connect my camera using USB Nothing appears on the screen so I take my memory card out of the camera and use the SD slot on my computer. I then get options as normal.
PS I have my settings to ask me every time.
Hoping you can Help
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8300 @ 2.50GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 3839 Mb
Graphics Card: NVIDIA GeForce 7100 / NVIDIA nForce 630i, 256 Mb
Hard Drives: C: Total - 297421 MB, Free - 216163 MB; D: Total - 297595 MB, Free - 155783 MB;
Motherboard: Packard Bell, MCP73PVT-PM
Antivirus: Norton 360 Premier Edition, Updated and Enabled

Read other answers

Hi its been a while since i was on this part of the forum.

I was doing a pandascan a while ago. I wasnt expecting much on it. Preparing myself for just a few spyware maybe as it had been a while since i last scanned my computer. After a while however it picked up these 2 files as suspicious:

C:\documents and settings\ben\my documents\ati updates\dcprosetup_15.zip[dcprosetup.exe][DCleaner.exe]
C:\documents and settings\ben\my documents\DCProsetup_15\DCProSetup.exe[DCleaner.exe]

Now i thought that these were legit files? Could it be a mistake on pandas behalf or should i look into it more? What are your opinons on the matter?

P.S. Thats twice now my internets konked out while on BC.... Sound supcious? Should i go into safe mode and try a few tests?

A:Possible False Negative?

Use the program in the link below to remove the malware.http://www.malwarebytes.org/rogueremover.phpDescription of malware:http://spywarefiles.prevx.com/RRIHGJ294489/DCLEANER.EXE.html

Read other 5 answers

My new HP Envy x2 notebook screen inversed its colours. Now in a pdf- or word documents have white letters and black background. Also staring icons have black background. Everything was in order for two weeks, but suddenly this black and white problem was there. How to correct this?

A:Screen went negative

Hi, If recently use option #3 of the following link will help:    http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/laptop-screen-shows-negative-col... Regards.

Read other 5 answers

Hi Folks'...

Anyone got any good source for me to buy a negative scanner ?

I have a load of older film that I want to now digitise.

Any advice help would be grately appreciated please, thanks

A:Where can I get a negative scanner ?

Read other 9 answers

Is there a way in Excel to set up a column so that all numerical entries will automatically be negative numbers?

Read other answers

I'm using Quattro Pro12 in MS Excel Mode.

When I format a negative number as (1234.56) and save the spreadsheet, that format is lost when I open that spreadsheet again. The format reverts back to -1234.56.

What am I doing wrong? The ( ) format just won't stick!


Read other answers

I know by formatting the cell you can select negative numbers to appear in red. I was wondering if there was a way to do that with zeros?

A:Excel and negative numbers

Hi there,

Yes, there is, but you'll need to do a custom format as there are no default formats for showing anything equal to zero in red. Now in order to do this, you'll need to understand a little of custom formatting. There are four items you can specify, and they are in specific order: Greater than zero, less than zero, equal to zero, and textual values. These items, are separated by a semi-colon ( ; ). So something like this...
This should explain them a little more...



Read other 1 answers

I downloaded my video from my camera and tried to view it through media centre and media player but it came out in the green negative. Our windows is vista 32 bit. Tried to download updates but came up with messages of not enough space - due to wrong download - was for xp. Then did the update for vista and said it wasnt applicable for the computer. Can you help me please. The computer always did it as it is only a few months old and the graphics card is an Asus EAH4650 and we have done all the updates for it just recently.

A:avi playback in green negative

Hello kiwibabs,
So, you have the latest drivers for your video card, and all the Vista updates.
From what you are describing, i would say it's a codec/file type error.
Can you check to see what format your video camera is, what format the files you are trying to play are.
What type of camera is it, make and model.
Take a look and post your results,good luck.

Read other 5 answers

hi , i seem to periodically run into this problem .

my digital camera takes movies in .mov format . when i go to view them in media player or quicktime they appear like over exposed colour negatives - lots of white , blue and yellow and no other colours . could someone tell me why this is and steer me to a solution please ?

thanks in advance

A:.mov file looks like colour negative !


Read other 1 answers

I just bought Otek FS-502 hoping to scan heaps of old 35mm negative, but I am rather disappointed in the quality of the images I am getting, they are wishy/washy (not sharp or clear). After I have transferred it onto my PC the dimensions are 2544 x 1696 but the size of the file is 500-600KB whereas my normal digital photos are 2-3MB, which I assume is the problem. Am I expecting too much of this Scanner or have I not set up the scanning process correctly? Or is it dependent on the SD card, I have tried a couple with same result.
Also another problem has emerged when I emailed a couple of photos (saved from my digital camera) as attachments to a friend; when I open up my sent message, at the top (above the addressee headings) there is a message "OA removed access to the following unsafe attachments in your mail IMG_795.JPG". so all I have is the hugely enlarged image in the email itself.
Hopefully you can understand my 2 problems/issues an have some easy resolution.

Many Thanks

A:Otek FS-502 negative scanner

Your unsharp scans are caused probably by you not setting a high enough scan resolution in your Otek's scanning software.

Read other 2 answers

Does anyone know if there is a slide/negative scanner adapter I can get for a Lexmark 5150 printer/scanner? If there is one, do you know where I can get it? I haven't been able to find one anywhere.

A:slide and negative scanner

Go to Porters.com they have a big selection of photo equipment.

Read other 3 answers

Not sure if this will be better here or in hardware.

I'm looking for comments/suggestions on a negative scanner. Can be an all in one, or a stand alone. Just would like something "easy."

A:Solved: Negative Scanners

Read other 16 answers

I need a formula that when value X is between, say 6 and -6, the result is True (or Pass) and when it is not within that range it is False (or Failed). If possible, I would like for this formula to be in one cell. Is this possible when there is a negative number in the formula? Here is what I have tried:

=IF(6>E14>-6, "Pass","Failed")

However, Excel does not appear to recognize the "-" in the formula as negative.


A:Formula with Negative Values

Without thinking about it much, just add 6 to each portion

Read other 3 answers

I use a very basic spreadsheet to work out my flexi-time each day. This works fine for positive numbers (ie. when I have worked my normal hours in a day) but when I have a negative amount (eg. when I have worked 10 mins less than my normal day) Excel displays ######## in place of the daily balance. Is there any way I can make Excel display the actual balance even when it is negative.

Thanks in advance.


A:Negative Times in Excel

Read other 9 answers

So apparently I have -1025 mb of memory

What's the deal? I've run the same program in 1 x64 virtual machine and 1 x86 machine, without issue.

It's probably because I upgraded this machine from 7100 -> 7264.

Does anyone know why the program is seeing -1025 mb? I can finish the install, but then the program won't boot up.

A:Negative Memory during app install

It has something to do with the way Win98 (minimum requirements) applications detect memory & hd space. I have seen the same things happen with HD space

Normally, the offending apps will install with no issue.

Read other 7 answers

I have a scanner for scanning film negatives which worked really well with Vista 32 bit but I have been unable to get it working with Windows 7 64 bit.

It is made by a company called Fujitac (who don't seem to have a website anymore) but it uses OVT Scanner drivers. Initially Win 7 didn't recognise it but after loading the drivers from the original CD it seems to be recogised. The driver version is Omnivision 5.2.5500.35 from 29 Jul 07 and I have no idea where to get a later version.

The scanner came with Photo Impression 6 software. When I go "Acquire from Scanner" it brings up the capture window but it remains blank and never shows an image of the negative that I wish to scan.

Any ideas would be gratefully received - I've wasted too much time on this already

A:Negative Scanner Not Working

Hello paust,

Welcome to 7 Forums.

Have you tried installing/running in Compatibility Mode.

Hope this helps.


Read other 3 answers

I have an excel spreadsheet (2002) Someone has entered in all the numbers that are supposed to be negative numbers like this 14.56- when you try and add all the numbers all together it returns a zero value because excel doesn't understand that it is a negative number because the minus sign should be on the other side of the value.

Does anyone know of a good idea on how to get all the - signs on the other side of the number or any quick way to make excel understand these numbers as a negative eg -14.56????


A:Excel Negative Numbers

Read other 8 answers

Help in converting B/W negatives into B/W positives, using Hp Scanjet5500c, HP Photosmart 7550 & Adobe Elements 2.

A:old black & white negative

hi there, what do you mean? YOU need help or you can help?
I found most photoprograms and digital imaging programs can change positive to negatives but none of any of my hardwares can do that.

Read other 3 answers


When I'm receiving live-stream video the sound is OK.
The problem is, that I get the video in neg. colours...
My OS is Windows XP.
On my notebook (Windows Vista)everything works perfect.
What can I do to fix this ?

Kind regards,


A:Solved: Negative colours

Read other 7 answers

I had just accidentaly dropped a weight on my laptop and when I opened it up everything was negative. Is there something I can do to fix the problem or something I can download?

A:Negative Effect for Monitor

If you physically damaged the screen, it has to be repaired. You can't download software to fix it.

Read other 1 answers

AVG 7.5 still works!
I am suprized but happy!

Anyone know the final cutoff date?

A:Potentially negative members name

28th February 2009 for the anti-virus, already gone for the snti-spyware.See here http://freeforum.avg.com/read.php?1,136697,backpage=,sv=

Read other 1 answers

Please is someone able to help?!

For a while now whenever i have tried to play any type of video file (dvd or downloaded file) on any player (winamp, media player, divx, to name a few) it looks like a negative. The sound is fine but the picture isn't. I can't describe it any better than to say it looks like a photographic negative!

I have been told to download some codecs which i have done but none of these have worked. I don't understand why this has happened, everything used to work fine!

A:Video Files Looks Like A Negative

to BC student_in_need,Have you updated your video drivers lately? How many colours do you have set in Display Properties? (see Control Panel>Display)To make it easier for people to help you, you need to give us some information about your system such as CPU type, RAM capacity, hard drive size, graphics card type, what version of windows and some details about your applications.

Read other 3 answers

Is it possible to scan an old B & W negative and print it out in normal B & W colors? If so, how? TIA.

A:Scanning & Printing from old B & W negative

It can be done but your results will depend on what type of scanner you have and what graphics programs you have.
Plan to spend some time and go through some trial & error to get the finished product just right.
After your initial scan I suggest you work with copies of the original scan so you can always try again.
Tell us more about your hardware/software.

Read other 3 answers


I've been going through my photos and film negatives.

Is there a way to get a picture printed without giving up the negative?
It seems photo places will send out your negatives for processing, but the developer won't return them like they used to.

I was wondering also why they don't return them, and what happens to your negatives (property).

Also, is there a way to view the negative without buying a negative strip reader (light machine).

Thank you

A:Film Negative Questions

I would never, ever hand a negative to any processor that did not ensure its return. I've never dealt with any photo printer that didn't return negatives.

There are ways to digitally process negatives into photos, and many high-tech commercial photo processing shops, even local ones, have these and can produce a print while you wait. These may not be quite up to the standard of regular print processing, but it's generally way more than good enough for old snapshots.

Read other 1 answers

Have asked in the past about scanning and got very good help, one additional question ,having negatives and photos of the same picture is it better to scan the photo or the neg,
Thanks for your past help.

A:Scan Photo/Negative

I would recommend the negative (if you have a negative scanner), if not then use the picture.

Read other 7 answers

Hey guys i need some help with my laptop. A month ago the LCD screen cracked inside and warranty would not cover is so I found a website and bought the LCD myself. i just installed it myself and I installed it correcctly and it all went well except now the screen is in negative picture, white is black and what not.

Is there something i can do to reset or calibrate the screen to have the colors corrected? or do i possibly have the wrong screen? The computer is a Sony Viao VPCEA24M

thanks in advanced for the help

A:New LCD displays negative color

Read other 6 answers

My virtual memory displays a negative amount when I let windows(98SE) set the size.
If I try to change the virtual memory size manually, there is a small positive number displayed, that automatically reverts to the negative 19 gigs when I click on the box. Windows will not let me change it.
I ran an old virus scan but did not find any virus. (Norton AV 2004)
Can anyone give me any suggestions? Thank you in advance.


A:negative virtual memory -19GB

Neither Norton Utilities or the free download utilities fixed the problem.


Read other 3 answers

I am trying to make a spreadsheet AGAIN. This is probably the 10th time in the past few years. I get so frustrated I just give up. I'm going to try to be a bit more persistent this time. I formated cells for numbers. I entered the amounts and then realized much later that the numbers should have been shown negative because they were a "cost" or out of pocket expense. I've tried to fix all the cells at once but I can't figure out how. So I have been doing one cell at a time which is FRUSTRATING. I also has other months that I will have to deal with this problem and was hoping you could help me figure out how to fix this. The following list shows the numbers I have changed to minus/negative. All the numbers below those minus numbers should also be negative. Do I have to do this one by one or is there a way to do it all at once?

Item Purch Price
HD shirt -$2.95
Danica Indy car shirt -$2.95
Steve Madden denim heels -$7.00
Mauve dress barn dress -$2.00
Brighton purse -$3.00
Silk spiegal dress -$2.00
HD shirt womans -$5.00
Ann Taylor clutch blue -$5.00
Napoli slip dress $2.00
Kate spade floppy hat $2.00
brown/white geometric dress $2.00
Blk/wht halter dress $2.00
C... Read more

A:Formating cells for negative numbers


Try this.
Save first to make sure we don't mess it up

This works if the values you want to change are all positive. It won't work for values that are already negative.

Select the cells that you want to make negative. Right click the selection and choose COPY.

In an empty column maybe next to the cells you selected if it is empty, right click a cell that you want to be the top cell in your list.



Click OK

That should make a column of negative versions of what you had selected. Then you can copy those and paste them over the positive numbers.

Hope this helps

Read other 4 answers

Hello, I have an Epson Perfection 1250 scanner all is working fine but I have no power to the slide adapter. It is plugged in. Any ideas?

Read other answers

brother dropped laptop and now it only displays negative colors, even after a restart. what can i do?

Read other answers

Is it possible to format a field to display negative numbers in red? If so, how?

Read other answers

http://www.bleepingcomputer.com/forums/sty...fault/crazy.gifA Summit Photofix slide/negative scanner which worked for several years has developed a glitch. When Photo Impression 6 is used to connect to the scanner the box in the program window giving all the scanners available has OVT scanner greyed out and cannot be connected.If Adobe Elements 5 is used, the box shows all the scanners including OVT. Clicking OVT connects to the scanner but when an attempt is made to copy a slide, the computer crashes.Have tried uninstalling & installing again but same result.Assumed Summit developed a fault so bought a similar scanner from Veho. This produced the same results so fault appears to be in interface.Restored back to date before scanner was installed this time but same result.Using Windows XP Professional - no major changes made.Help please.Patrick

Read other answers

hello im sorry but im a noob in this forum but i really need some help, for some reason my hp pavillion dv6000 vista home premium with a Nvidia card is having display problems, the only way i can think to explain it is the color looks similiar to a photo negative that you get when you get pictures developed i cant figure out where to change this or how it even happend plz help anyone i dont know what to do

Read other answers

Hi all, I am new to scanners and I have a new H/P scanner with transparent materials adapter and holding rig for negatives. I assumed that scannning a negative would produce the best end result. However I scanned the 4x6 color print and it came out much better. Which way should produce the best results? Scan the print or scan the negative?

I did search the forum first.

A:Scan a picture or negative for best quality?

From my experience the negative is much better. Make sure you're setting the DPI at the maximum of what the scanner can handle. Also get a can of compressed air and blow the the dust off the negatives before scanning them. Even a little spec shows up.

Read other 3 answers

Greetings from Sydney, Australia.

In my last job we used Lotus and you could elect to show minus amounts with brackets around them. Now I have a new job and we use Excel 2000 that shows negative amounts with a minus sign, only. You can't change the format by using Format, Cells, Number.

How do I get negative amounts to show with brackets around them? Also, if this is possible, how do I nominate this feature as a default whenever I start a new Excel worksheet? For that matter, even if it isn't possible, how do I nominate any default options?

Thanks mate.

A:Excel - can't get brackets around negative numbers

Hi Lee,

You can make the changes you want by using Format - Cells - Number.

Just choose Custom andyou will see a scroll down list of possibilities. None of these include bracketing so you just have to add them yourself in the TYPE field.

For instance, make


read as


to get the result
in your selected fields.

Read other 2 answers

i have the QB pro 8 and i am installing it with the company details. i went into the banking section to install the opening balance (which at the time ) was a negative balance. QB will not allow me to put in a negative figure. any ideas how i do it?

A:quickbooks pro 8 negative banking figures

Could you start of with Zero first then put in the neg number after that. Not sure if that would work or not.

Read other 2 answers