How do you execute a Macro on loading a worksheet (that is, without having to click a button or cell)? --- Message posted from http://www.ExcelForum.com/

I have tried inserting as an object but it still only shows the first page. In the past to get round it I have taked a snap shot of each page in the PDF which...

Hi, i need to enter the current time in a cell with hh:mm:ss foramt there is a short cut CTRL+SHIFT+:, although it shows me the hh:mm:ss, but the second is...

ever since I've installed 2007, all my files will start up 2007 when I double -click them. Can I set up my machine so that: xlsx will open up 2007 and ...

Hi Guys I have a date entry form. One box requires a date. I have several users using the form, each types the date in a different way. I would like a...

Hi I have a bunch of graphs in an excel document. I use them in a lot of different power point presentations. I use the function copy/paste special/paste...

When I'm in Excel I must be hitting a key combination that creates havoc for me. Everything will be working fine and out of nowhere when I try to choose a...

Somehow I got a micro version of an Excel spreadsheet and don't know how to return to the normal sheet view. HELP!!!

Hello All! I note that m.p.excel.misc disappeared this morning from msnews.microsoft.com. It seems to be alive and well on eternal-september but I restored...

I have read previous messages and responses regarding maximum text length in cells, not visible on screen, or when printing. I am using Excel 2007, and have...

I have setup a number of stack symbols and Excel 2007 recognizes most of them. However, it does not recognize WU - Western Union or Mon - Monsanto. Is...

Hi, sometimes when I paste text from a webpage onto my spreadsheet into one cell, the pasted text takes over two or more cells. I don't mean the text just...

I am trying to pull certain characters based on a criteria for the third position character. In Column A, I could have a code such as BB11 or a Code such...

Hi, Ive got a spreadsheet with staff information such as network username, first name, surname, department, job title, ethnicity, age etc... How do I (if...

Good morning, I have developed a spreadsheet at work and I have now been asked to share with the other departments. I would like to somehow protect from...

Put together a quick macro to assemble a pivotchart, nothing fancy just ran through it recording and tried to run it on the same data afterwards, and have...

How do I add only the positve numbers in a column with both positive and negative numbers?

Hey All, using the following vba code, i am trying to copy all the rows that have the word "OK" on column A, example i have data on row 1 to 20 and the...

This is probably very simple but I just don't see it. How can I see if a (variant) variable is a range or something else (e.g. a string) Sub WhatIsIt() Dim...

Hi. I need some samples of ISNA and ISERROR functiones. Is there a web where I can download samples of them? Thanks in advance Regards, Emece.-