I am now with a new company. I had a macro or VB program to email a worksheet, which I got from this forum. All one had to do was click the button with the...

Hi, I made a spreadsheet to calculate my hours .. here is what I have .. Week Ending Hours Worked Hours Paid Balance Note What I put in the number of...

I have a huge spreadsheet that contains a list. I don't want people to be able to modify the data in the spreadsheet but I do want them to have the ability...

in access 2003 I have code that will stop users from printing the sheet.Now that I have added a macro users can print if they do not enable the macro.Is...

is there a registry setting for "update links on save" in the options-general-web options? i'm interested in setting this via a GPO setting. running windows...

I have a large workbook (size about 10 MB) consisting of about 40 sheets summarised into about five sheets. When I change a figure in one sheet it used to...

When entering data on an Excel 2003 worksheet, when I pause the system does an undo, and sometimes several levels of undo. I know it is an undo as I can hit...

WinXp pro SP3 Installing Excel security update KB 958437 fails. I've done it through the auto update or downloaded the individual update and both fail. No...

I have formatted a cell (cell A) to link to other cells (other cells) and put each other cells info on a seperate line in my linked cell (cell A). However if...

Hello, I'm working in Excel 2007 and every time I open a file with Links Excel disables the content. I would like to change the settings so that Excel does...

Several times now I've seen modules run until they hit an error and instead of going into break mode and allowing me to debug the errors the code just stops...

I have to keep the formulas in a template, but want to remove the value from the cel. For example, I don't want someone to see the calculation total the...

I have received a workbook with a custom color palette. Problem I experience and I do not know how to solve: - I open this book (custom color palette) - I open...

I'm running Excel 2007 and would like to save an inferred XML Schema. Based on what I've found, I need to use the Excel 2003 XML Tools Add-in to do this. ...

Hello I have summarised data within a pivot table. This shows number of fees in November by account number. I now want to change this so it only shows...

is there a way to change the default formatting (color, text format, etc) for all comment boxes or update the formatting for all comment boxes without having...

I cant seem to write an equation to solve the problem below. I can do it manually by changing a countif formula, but would like it more automatic. I have a...

A1 B1-B200 concat unique formula numbers I am using a concatenate formula in column A that uses column B as a...

I work at a school and we have a lunch count that we do in an Excel spreadsheet. The teachers update their homeroom counts on a daily basis and it all gets...

Within Column B there are various product codes. Each code consists of a mixture of alpha and numerical characters. In Column B some of the codes are...