Software :: Excel 2004 - Disable Macro Message?
Dec 22, 2005
In Excel 2004, I created a macro. I then deleted it using the Tools --> Macros... dialog box. I still get the message about enabling/disabling macros when I open the file. I have tried using the VBA Editor to delete it, but I don't see a "Module 1" (or anything else for that matter) that contains the macro.
I know I can turn off the macro warning in the preferences, but I'd rather figure out why I'm getting the message and get rid of it without turning off the macro warnings.
View 1 Replies
ADVERTISEMENT
Mar 4, 2009
I spent at least 30 minutes struggling with my new computer because the path name of my macros had changed. Turns out, you must manually change every item in your Excel palettes that calls a macro. That's easy, you control click on the palette icon, select 'assign macro', and choose the macro.
But although that command was not greyed-out, when I selected it, nothing would happen. There was no error message.
I found no solutions on the internet, and in the course of the 30 minutes, tried various desperate things involving new taskbars, searching for mysterious excel.xlb files, VBA scripts to build taskbars. In the course of that, I broke a bunch of things on the palette. But I found the solution, and joined this group, just so I could tell the world.
You have to have some worksheet open.
Yes, that's it. It makes no sense, but that's it.
View 1 Replies
View Related
Dec 8, 2009
I am trying to make an excel sheet on all of my photos. I have found a program to exports exif information in html or txt files and it is the only program I have found that displays the fields I need (Windows XP title, comments, keywords, etc). Anyway, the program will only export all of the data (I can't just select the fields I want) and it also makes a new files for each photos (and names them whatever the photo is named so yes sequential). I have been playing with importing html and txt files into Excel 2008 and need help. I am looking for a way to only import the rows I need and to automate it so I don't have to do 10,000 photos by hand.
On another forum, it was suggested to use VBA (visual basics) in excel on windows which looks promising but I know little about it and will have to borrow my sister's dell to do. Another suggestion was to combine the text files and use a Macro in excel in which I also have little idea on how to use. Can Apple Script or Automator or any thing else help me here? I know Excel 2008 for Mac doesn't have VB but what about macro on it?
View 10 Replies
View Related
Mar 23, 2010
Does anybody know of an ODBC driver I can use with MS Excel 2004 ?
View 1 Replies
View Related
Sep 1, 2009
I'm trying to print an Excel 2004 .xls spreadsheet file where I'm using to record attendance for the class I teach. I have my main Column A with Rows A-X and it shows up fine, I imagine because there is content in the boxes.
But I also have Columns B-L and rows A-X with nothing in their cells, but when I print it, they won't print. I need these blank because I'll check them off if the child in the first column attended the lesson. How do I make it so my many blank cells will print as well?
View 1 Replies
View Related
Oct 28, 2010
I was previously using Excel with no problems, then installed updates Tuesday, now can't open .xls file last used Monday?
View 2 Replies
View Related
May 14, 2008
I'm getting a weird error when I try to open Microsoft Excel 2004. "You can't open the application "Microsoft Excel" because the Classic environment is no longer supported."
1. Excel used to work just fine (I'm not sure if I've used it since I upgraded to Leopard)
2. I've seen other people say on forums that the MS Office 2004 suite works fine with Leopard
3. As far as I know the Classic environment was phased out in Leopard, though I don't think I've ever used the classic environment
4. All my other MS Office Apps work
I'm not having much luck with google, hopefully it's a dumb configuration thing that I don't know about.
View 10 Replies
View Related
May 10, 2012
I am upgrading to Lion and Microsoft Excel and Office will not run under Lion.I am upgrading to office 2011.Do I need to uninstall office 2004 prior to installing 2011.If so how do I uninstall 2044.
Info:
iMac, Mac OS X (10.6.8)
View 4 Replies
View Related
Nov 2, 2008
Excel opens up a gigantic size blank document anytime I launch it. I gather there is no way to disable it giving me a (useless) blank document. But is there a way to not make the stupid document take up 90% of my screen?
View 17 Replies
View Related
May 21, 2010
This might be the weirdest software bug I've ever seen. It looks like maybe a programmer for Microsoft was having some fun. Here is what happens:
A spreadsheet that a coworker uses for purchase order requests has several cells in a column with a SUM field that calculates the number of units to purchase multiplied by the unit price (not sure why they use SUM for just a multiplication, but I don't know if that matters).
If you delete the contents of one of these cells and type in something else (or just type something else without deleting first), then exit the cell, an error message pops up that says, "You can't do that!!!!! So quit trying!!!" with options Cancel and Retry.
Retry doesn't do anything, Cancel clears what you put in the cell. Copying and pasting the cells into a different row creates the same issue.
I've attached several screen shots to show steps to reproduce:
Picture 1 - column F has the suspicious cells
Picture 2 - the calculation
Picture 3 - after deleting the contents
Picture 4 - enter some text, before exiting the cell
Picture 5 - error message after exiting the cell
The only workaround was deleting the entire row and entering those calculations again. I have no idea what to make of this, and internet searches have come up empty.
View 1 Replies
View Related
Mar 22, 2009
In Apple mail, is there a way to disable the message that warns you when you're about to send an e-mail w/ no subject?
View 2 Replies
View Related
Mar 1, 2009
Is there a size limit for importing an Excel File into Numbers? The error message says the file is too large. Has this been changed in i-work 09? The file has multiple sheets that refer to each other, but i can't even open at this point. It is 3.1 MB.
View 4 Replies
View Related
Sep 8, 2010
I want a program where I can press some sort of combination of keys and I'll get a prompt, and then I can type a command that I can customize and it'll type the custom output.
For Instance:
I hit option-alt-space and something comes up and i type gotoserver and it types ssh -l user 192.168.1.1 so it types it in the terminal for me.
or maybe even opens up terminal and types that in for me maybe it could even wait for a prompt or for some time and then type the password too.
I got quickeys but I can't get it to do anything like this.
View 5 Replies
View Related
Feb 6, 2009
It seems that every word doc I create has a self generated macro virus embedded in it and when I go to email it as an attachment GMAIL doesn't allow it to be attached.
I also get the warning window about disabling Macros when ever I go to open a word doc on my MacBook Pro.
How do i alleviate this virus from existing docs without destroying content and also rid my laptop of future issues with this virus.
View 1 Replies
View Related
Sep 4, 2014
I do a simple copy and paste, but wanted to know if I can create a customize "Hot Key" on my keyboard that will paste in the word? Lets say the phrase is "Confirmed: ID".
View 1 Replies
View Related
Feb 20, 2007
I have searched for this, but cannot find any.. I need to do some raw mouseclicks on certain coordinates on the screen, and then loop it forever until I stop it. Anyone know any programs that can do this?
I tried to fiddle around with apple script, but can't figure out how to do that.
View 2 Replies
View Related
Mar 8, 2010
easy and free way to create a macro that will switch to Finder and hide others from any application?
View 3 Replies
View Related
Apr 19, 2010
ok so I have 13000 track on my computer. I probably hate 9000 of them. This collection has been building up for a good 10 years. I like to listen to music on random. I want to be able to either hit "next" or "delete".
I dont want to have go to itunes window, hit delete then "Move to trash". I want the delete button to do that. even if I'm not on the itunes window.
thoughts? It also doesn't have to be itunes. I don't care what it is. if its not itunes i can use it for a month to syphon through all my music then all thats leftover Ill enjoy through itunes.
View 3 Replies
View Related
Mar 23, 2009
some of my Word documents are infected with a macro virus. I'm not sure how many are infected, although I know it's not all Word docs. I'm running Office 2004 for Mac Student and Teacher Edition. How can I fix this? I'd like to prevent other docs from also becoming infected. I have no anti-virus installed and I'm still running Tiger 10.4.11 (hoping Apple releases Snow Leopard soon so I can finally upgrade).
View 6 Replies
View Related
Feb 6, 2009
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
View 6 Replies
View Related
Apr 13, 2010
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
View 1 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
View 1 Replies
View Related
May 22, 2010
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies
View Related
Nov 10, 2009
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies
View Related
Mar 24, 2010
Recently switched from PC to Mac, I really miss the F2 functionality in Excel for Mac
Or, more specifically , I am missing the possibility to place the cursor in a cell and hit F2 to edit the formula as well as Excel color-coding all cells that are referred to from the current cell.
I know I can do the same by clicking in the "formula builder toolbar" but I don't wan't to have to reach for the mouse each time... does anyone know if Excel for Mac has a similar feature / keystroke to use
View 2 Replies
View Related
Apr 16, 2012
When I want to REPLY to a message, I do not automatically get a 'send' icon after composing the message. I have to save it as a draft and then send it.
Info:
MacBook Pro
View 1 Replies
View Related
May 30, 2010
1. What are the file extensions for MAC excel? Do they differ from PC excel?
2. What are the differences between MAC excel 08 vs PC excel 07?
I have had some work done by a provider in elance in PC excel 07 and now i can not read the spread sheet in my MAC environment. The provider is saying that MAX and PC excel versions are 100% compatible - I disagree and need to know the differences but I am not tech/program savvy.
View 1 Replies
View Related
Mar 20, 2012
I am using the Mail (5.2) app in OS 10.7. I have my Inbox sorted by decending date, i.e. newest mail at the top. When I delete a message, Mail currently selects the message above, i.e. the one that had arrived after the deleted one chronologically. Since I work through my emails from newest to latest (usually), I will already have seen the newer mesage. What I want to see is the next message on the list, i.e. the next one, which arrive before the deleted one. My question there is: How can I advance to the previous message rather than the next one (chronologically) after deleting a message?
Info:
iMac (27-inch Mid 2011), Mac OS X (10.7.3)
View 3 Replies
View Related
Jun 6, 2009
I've just installed new Mac Leopard to my G5 (old version was Tiger), but the Microsoft Office Mac 2004 did not work: I could not print out any M.O. documents? I did google and found that MO Mac 2004 work with Leopard, but somehow not on mine!!
View 1 Replies
View Related
