Search results for query: *

Hi all Just wondering if anyone can help with my query. All I would like to know is if a spreadsheet is saved as .htm, is there a way to save the spreadsheet so that macros will still run. While building a sample sheet I could get links to work but buttons running macros didn't seem to. Any...

Hi all, Hope someone can help. A web site I have taken over supporting has links that I am having problems with. From the home page a link opens an excel spreadsheet in the browser, (current code: <a href='file location'>) From the spreadsheet another link then opens another webpage. The new...

Hi everyone This maybe really simple but I tried most of the code I could find and can't get it to work. What I would like to do is on a button click > Open worksheet > Search down column A till the first empty cell > Enter details in cells along this row id. I know how to open the...

Hello everyone Can anyone tell me how I get the button click values from a message box. I need the values to complete an if else statement in the code. Thanks in advance for the help Craig

I have created a Macro that creates a new work sheet and then copies formatting from 2 other work sheets to make an order form. What I would like to do is add buttons to the spread sheet when it is created so that when they are clicked the order amount for the associated item is entered in the...

Hi there I have an Excel Work book that contains various order forms. I have macros that create new work sheets copying the original Order forms depending on which is run. What I want to do, I would like to change the name of a newly created worksheet to the date the work sheet was created. Is...

Hello everyone received a file with a .123 extension. I don't recognise the format and am unable to open it in Excel which I was told I would be able to. Can any one advise me on how I might be able to get it open. Thanks Craig

Hello I recently created a spread sheet to provide reporting on regular checks that need to be carried out. Multiple users access this spread sheet and I would like to be able to store their user id's in a cell when they open the spread sheet. As only one user can access this spread sheet at a...

I need to know how to program a button on an Excel spreadsheet to colour a single cell in a column when clicked and then on the next click the next cell is coloured and so on. I have written a macro that does half the job(see below)but I can't figure out how to go to the next cell on the next...